March 2008 - Posts

• Is SQL Server "keeping up" with MySQL?

  I read a comment in a Connect suggestion today that implied that implementing their suggestion would allow SQL Server to " keep up with MySql ." Regardless of the actual suggestion, that made me laugh out loud... and since I was on the train, that got Read More... Posted Thursday, March 27, 2008 10:00 AM by AaronBertrand | 27 Comments Filed under: SQL Server 2008, MySQL

• Which to use: "<>" or "!="?

  For some, the answer is easy. Since Tibor reminded me several months ago that <> == standard and != <> standard (and yes, I used that notation on purpose), I have been making a conscious effort to use only <> going forward. Similarly, Read More... Posted Thursday, March 20, 2008 7:51 AM by AaronBertrand | 29 Comments Filed under: SQL Server 2008, standards, ANSI, compliance

• Increased limits for columns / indexes / statistics

  I am still on the fence about whether this is a good thing or a bad thing. However, in the next build of SQL Server 2008 you will be able to get your hands on, you will find that some element limits have changed, just a bit. With the introduction of sparse Read More... Posted Tuesday, March 11, 2008 3:33 PM by AaronBertrand | 8 Comments Filed under: katmai, SQL Server 2008