Feeds

back to article No joke: Microsoft SQL Server 2012 debuts on April Fools' Day

As expected Microsoft has released SQL Server 2012, formerly codenamed Denali, to manufacturers and will be making the final code available on April Fools' Day. "This is the cusp of a major milestone for Microsoft and SQL Server," Doug Leland, GM of SQL marketing for Redmond told The Register. "It's been battle-tested by over …

COMMENTS

This topic is closed for new posts.
Silver badge
Joke

Denali?

Or is that Denial ?

1
0

it is broken

this wont' work in sql 2008

select 1 / i from x where i <> 0

divide can be done before where part is checked and it happened to me so i know it.

also m$ admit it is true here http://msdn.microsoft.com/en-us/library/ms188295%28v=sql.100%29.aspx

they make it look hard to happen but its easy. they dont tell people about it. they say it is faster but it is broken.

0
4
Silver badge

Re: it is broken

This article is not about SQL Server 2008.

Did you bother to read it?

0
1
Anonymous Coward

Re: it is broken

-- a Common Table Expression will work :

With Safe_CTE as

(

SELECT i FROM x WHERE i <> 0

)

SELECT 1 / i FROM Safe_CTE

-- Of course, if i is an integer type, your results aren't going to be very useful!

1
0

Re: it is broken

no it is not certain even with cte. m$ write-up say how to make it safe the only way. and it is not a bug say m$ it is <<by design>> so maybe in sql 2012 also.

0
0

On a Sunday?

Really?

2
0
Anonymous Coward

You'd have thought this would be Windows 8 release date judging by the joke that is Metro.

0
0
Silver badge

shut up, Barry. You're boring.

3
2

SQL server 2012.....Wait, What!

Well I suppose it's another upgrade path to consider, when my beloved SQL 2000 servers reach their end of life in 2013.

1
0
Anonymous Coward

Newcastle really are doing well aren't they.

Just last week I notice all that Huawei. Now there's Hadoop.

I wonder what's next? Divvent? or maybe Keesyde I reckon.

0
0
Mushroom

Ya didnt need

An Oracle to figure that out , canot wait for the SQL

0
0
This topic is closed for new posts.