September 23, 2008 | SQL Server

SQL Server 2008 Cumulative Update 1 is available

For those waiting for the first CU for SQL Server 2008, your wait is over.  You can get it in KB #956717.  The build # is 10.00.1763.00.

As with SQL Server 2005, you can simply submit a request for the CU, and it will get e-mailed to you.  Be sure to request the correct platform(s), as many people have complained in the past that they wanted the x64 edition but got the x86 binaries, or vice versa.

Some interesting things I noticed:

  • They repeated the "trace flag fix" that forces the optimizer to obey TOP 100 PERCENT…ORDER BY in a view.  (You know, for those of you too lazy to add ORDER BY clauses where they belong.)  See KB #926292 for more information.
  • They fixed the MERGE bug that Itzik reported in Connect #357419.  You can see KB #956718 for details of the fix.
  • Outside of some minor IntelliSense issues that haven't affected me so far, not many tools issues have been addressed.  🙁
  • At least half of the fixes are for Reporting Services, which makes me think that it was the component least ready to ship.

5 comments on this post

    • AC van Bers - September 23, 2008, 3:28 PM

      Too bad we need to contact MS to get it..
      Anybody with a direct download?

    • Jason - September 23, 2008, 5:02 PM

      I bet someone had scream really loud to get that order by workaround put in.

    • AaronBertrand - September 23, 2008, 6:33 PM

      AC van Bers, you just have to fill in an online form.  You don't have to call MS or deal with support directly at all.

    • Glenn Berry - September 23, 2008, 9:20 PM

      Nice to see this come out.

    • Gail - September 23, 2008, 10:48 PM

      Jason, if you look at the details of the kb on that order by 'bug', it only works with a traceflag on, if the DB is in compat mode 80 and the traceflag must be in place before the DB is migrated to 2005/2008.
      It's noted there that the 2005 behaviour is the intended behaviour and that's how it will be in the future

Comments are closed.