SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Yukon Details on Technet
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 10/28/2003 :  07:35:56  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

Australia
1591 Posts

Posted - 10/28/2003 :  17:40:27  Show Profile  Reply with Quote
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.."
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 10/28/2003 :  19:45:56  Show Profile  Visit AjarnMark's Homepage  Reply with Quote
David, I agree.

http://weblogs.sqlteam.com/markc/posts/384.aspx

--------------------------------------------------------
Visit the SQLTeam Weblogs at http://weblogs.sqlteam.com
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 10/29/2003 :  04:15:48  Show Profile  Reply with Quote
quote:
- CTE? What the F*$#@ is a "Common Table Expression"


Itzik Ben-Gan has an interesting article in the November edition of SQL Server Magazine that covers this:

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=40206
Go to Top of Page

byrmol
Shed Building SQL Farmer

Australia
1591 Posts

Posted - 10/29/2003 :  04:46:33  Show Profile  Reply with Quote
Thanks Arnold.. Some good info there.. I especial like the DDL triggers.

DavidM

"SQL-3 is an abomination.."
Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

United Kingdom
846 Posts

Posted - 10/29/2003 :  16:49:36  Show Profile  Visit jasper_smith's Homepage  Reply with Quote
There is a much expanded version of the SQLMag article here
http://msdn.microsoft.com/library/en-us/dnsql90/html/sql_YukonTSQLEnhance.asp


HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27
Go to Top of Page

Lavos
Posting Yak Master

USA
200 Posts

Posted - 11/06/2003 :  22:46:40  Show Profile  Reply with Quote
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
Go to Top of Page

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 11/06/2003 :  22:53:18  Show Profile  Visit robvolk's Homepage  Reply with Quote
What's the difference between a SQL Server temp table and an ANSI temp table? Is one more (or less) temporary than the other?
Go to Top of Page

byrmol
Shed Building SQL Farmer

Australia
1591 Posts

Posted - 11/06/2003 :  23:08:59  Show Profile  Reply with Quote
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.."
Go to Top of Page

Lavos
Posting Yak Master

USA
200 Posts

Posted - 11/13/2003 :  20:23:02  Show Profile  Reply with Quote
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
Go to Top of Page

ehorn
Flowing Fount of Yak Knowledge

USA
1631 Posts

Posted - 11/15/2003 :  10:27:00  Show Profile  Reply with Quote
Graz had made mention of the new varchar(max) datatype
http://www.sqlteam.com/item.asp?ItemID=11986

also AjarnMark
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=21866

and that Varchar(max), nvarchar(max), and varbinary(max) will hold up to 2 GB of data.

Does this mean no more local variable limitations of 8000?
declare @ReallyReallyBigHunkOData varchar(2147483648)

Does anyone have more info on this datatype behavior in Yukon?

Edited by - ehorn on 11/15/2003 10:57:19
Go to Top of Page

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 11/15/2003 :  12:00:37  Show Profile  Visit robvolk's Homepage  Reply with Quote
You would declare it as varchar(max), and not worry about setting a size:

declare @a varchar(max)
set @a='Hello World!'
select @a
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000