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.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

5 Responses

  1. Gail says:

    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

  2. Glenn Berry says:

    Nice to see this come out.

  3. AaronBertrand says:

    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.

  4. Jason says:

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

  5. AC van Bers says:

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