| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-10-28 : 07:35:56
|
| Microsoft has released a couple of articles about Yukon. These are all pretty detailed and include some screen shots. Article Link. |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-10-28 : 17:40:27
|
| I only read the "Overview", but I am impressed.- Non blocking index manipulation - Excellent..- Database View - Perhaps a solution to temporal data?- Database Mirroring - Cheap redundancy!- Greatly improved recovery operations- Nice touches to QA!- XQuery and XML Data Type - BOOOOOH!!!!!!!!- New CLR Native object model (SML) replaces SQLDMO- Recursive queries - The Death of the Nested-Set in SQL Server?- CTE? What the F*$#@ is a "Common Table Expression"- PIVOT & UNPIVOT - For the cross tab queries freaks...- APPLY operator? Relational? Hardly... It says "once per each row"... Bit suspect on this.- BEGIN TRY/ BEGIN CATCH -- THANK YOU DavidM"SQL-3 is an abomination.." |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2003-10-28 : 19:45:56
|
| David, I agree.[url]http://weblogs.sqlteam.com/markc/posts/384.aspx[/url]--------------------------------------------------------Visit the SQLTeam Weblogs at [url]http://weblogs.sqlteam.com[/url] |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-10-29 : 04:46:33
|
| Thanks Arnold.. Some good info there.. I especial like the DDL triggers.DavidM"SQL-3 is an abomination.." |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-10-29 : 16:49:36
|
| There is a much expanded version of the SQLMag article here[url]http://msdn.microsoft.com/library/en-us/dnsql90/html/sql_YukonTSQLEnhance.asp[/url]HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
Lavos
Posting Yak Master
200 Posts |
Posted - 2003-11-06 : 22:46:40
|
| Yeah, APPLY's run for each row doesn't seem relational, but it's probably as close as we're going to get to a including a rowset sub-query.I'm really liking some of the enhancements in T-Sql, though I really wish they would've added ANSI temp tables. IIRC, Oracle has them, and it'd save me a lot of hassle.----------------------"O Theos mou! Echo ten labrida en te mou kephale!""Where theres a will, theres a kludge." - Ken Henderson |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-06 : 22:53:18
|
What's the difference between a SQL Server temp table and an ANSI temp table? Is one more (or less) temporary than the other?  |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-11-06 : 23:08:59
|
| This should probably be in the Yukon forum but the "Quick reply feature is just too handy...With the introduction of XML data types/XQuery and CTE (Thanks Arnold), can anybody guess which is going to be faster for representing/manipulating hierarchies?DavidM"SQL-3 is an abomination.." |
|
|
|
Lavos
Posting Yak Master
200 Posts |
Posted - 2003-11-13 : 20:23:02
|
| An ANSI temp table is declared as part of the database schema as opposed to being declared inline in a stored proc. At the begining (end?) of a connection it is cleared and you can only see rows inserted on your connection. Obvious benefits follow from having it created declaratively. I hate hunting down temp table creation to update their structures if the schema changes.You could hack one together using a regular table, @@SPID, and a view, but it's hard to make sure you clear out old rows since there really isn't a built in way to do actions automagically when a new connection is created AFAIK. (and of course, connection pooling can screw this up. Hmmm.)----------------------"O Theos mou! Echo ten labrida en te mou kephale!""Where theres a will, theres a kludge." - Ken Henderson |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-11-15 : 12:00:37
|
| You would declare it as varchar(max), and not worry about setting a size:declare @a varchar(max)set @a='Hello World!'select @a |
|
|
|
|
Article: Yukon Details on Technet