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.
  1. Anonymous Coward
    Joke

    Denali?

    Or is that Denial ?

  2. namaa

    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.

    1. dogged

      Re: it is broken

      This article is not about SQL Server 2008.

      Did you bother to read it?

    2. Anonymous Coward
      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. namaa

        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.

  3. Barry O'Connell

    On a Sunday?

    Really?

  4. Anonymous Coward
    Anonymous Coward

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

    1. dogged

      shut up, Barry. You're boring.

  5. moonface

    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.

  6. Anonymous Coward
    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.

  7. ideapete
    Mushroom

    Ya didnt need

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

This topic is closed for new posts.

Biting the hand that feeds IT © 1998–2021