2008 CTP is out - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

The Yak Corral

2008 CTP is out

Author

Topic

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-06-04 : 21:22:11

It's hard to believe, but here it is:

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5395

www.elsasoft.org

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-05 : 03:54:41

I am not able to open that link

I am getting GATEWAY TIMEOUT !

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-05 : 04:19:38

I downloaded it and is running!
Cool...

Look at this Books Online excerpt:

USE AdventureWorks;
GO
SELECT SalesOrderID, ProductID, OrderQty
    ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total'
    ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg'
    ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count'
    ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min'
    ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'
FROM Sales.SalesOrderDetail 
WHERE SalesOrderID IN(43659,43664);
GO

Peter Larsson
Helsingborg, Sweden

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-05 : 04:20:10

yeah i've already installed it on a virtual pc.

It installs OWC11

we still have SSMS...
we also get the UPSERT or in T-SQL MERGE Statement
also this works:
declare @i int = 5
select @i++
select @i

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-05 : 04:28:58

UPDATE now also supports TOP operator, as well as DELETE.

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-05 : 04:29:35

Time to create new forums for Katmai?

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-05 : 04:32:08

quote:
Originally posted by Peso

UPDATE now also supports TOP operator, as well as DELETE.

Peter Larsson
Helsingborg, Sweden

TOP in UPDATE/DELETE was supported by SQL 2005 as well, isn't it?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-05 : 04:36:11

Yes. See that now. Did that come with SP2?

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-05 : 05:00:03

I think it was part of SQL 2005, not an extension added in SP2. Not sure though !

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

pootle_flump

1064 Posts

Posted - 2007-06-05 : 08:03:40

quote:

Originally posted by Peso

I downloaded it and is running!
Cool...

Look at this Books Online excerpt:

USE AdventureWorks;
GO
SELECT SalesOrderID, ProductID, OrderQty
    ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total'
    ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg'
    ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count'
    ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min'
    ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'
FROM Sales.SalesOrderDetail 
WHERE SalesOrderID IN(43659,43664);
GO

Peter Larsson
Helsingborg, Sweden

Lol - could have guessed that would be the first thing you'd check.

Anyone know typical turn around from CTP to release?

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-05 : 08:20:53

my guess is late november 2k8

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2007-06-05 : 08:27:09

SQL 2005 was First slated for a 2003 release date

First post in the Yukon folder = 11/03/2003 : 16:15:45

which says "In Yukon Date and Time will be separated from each other" ... Hahahaha!

Kristen

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-05 : 09:49:11

<<
which says "In Yukon Date and Time will be separated from each other" ... Hahahaha!
>>
Does it apply for next version as well?

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-05 : 09:49:55

quote:
Originally posted by harsh_athalye

I am not able to open that link

I am getting GATEWAY TIMEOUT !

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Slow internet connection?

Madhivanan

Failing to plan is Planning to fail

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-05 : 09:55:58

supposedly they will be separated... we'll see if they really are...

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2007-06-05 : 10:00:29

supposedly they ARE separated in SQL2005 ... you just need to sue a CTP to implement it!

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2007-06-05 : 10:02:03

quote:

Originally posted by Peso

I downloaded it and is running!
Cool...

Look at this Books Online excerpt:

USE AdventureWorks;
GO
SELECT SalesOrderID, ProductID, OrderQty
    ,SUM(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Total'
    ,AVG(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Avg'
    ,COUNT(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Count'
    ,MIN(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Min'
    ,MAX(OrderQty) OVER(PARTITION BY SalesOrderID) AS 'Max'
FROM Sales.SalesOrderDetail 
WHERE SalesOrderID IN(43659,43664);
GO

Peter Larsson
Helsingborg, Sweden

You can do that in SQL 2005 ...
http://www.sqlteam.com/item.asp?ItemID=26943

- Jeff
http://weblogs.sqlteam.com/JeffS

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-06-05 : 10:15:31

quote:
Originally posted by Kristen

supposedly they ARE separated in SQL2005 ... you just need to sue a CTP to implement it!

sue a CTP, huh? how exactly do you sue a CTP?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Kristen
Test

22859 Posts

Posted - 2007-06-05 : 11:38:33

You'll be needing a Microsoft API for that ...

Edit: The Microsoft Litigation API I expect ...

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-06-05 : 11:46:59

that API is useless. every method just pops up a EULA, no matter how many times you accept.

elsasoft.org

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-05 : 11:57:56

quote:
Originally posted by madhivanan

<<
which says "In Yukon Date and Time will be separated from each other" ... Hahahaha!
>>
Does it apply for next version as well?

Madhivanan

Failing to plan is Planning to fail

I think they have separated this in Katmai, I remember a vague mention about this at the MVP summit where they showed us a demo of some of these features.

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources