Welcome to SqlAdvice Sign in | Join | Help

February 2007 - Posts

SQL Server 2005 SP2 Improvements

Posted Monday, February 19, 2007 11:02 AM by michael.k.campbell
If you do a lot of scripting, SP2 for SS 2005 is going to be a must-have. Luckily it was just released . Here are some of the BIG improvements for people who like to script a lot: Generate Script Wizard . You can now specify that the scripted objects Read More...
0 Comments
Filed under: ,

Burned again by HyperThreading on SQL Server 2000

Posted Tuesday, February 13, 2007 11:51 AM by michael.k.campbell
One of my clients recently had a problem where a query with a semi-measly execution cost of .3 was taking 25 seconds to return. Worse, forcing the query to use a suitable index (instead of the PK with accompanying bookmarks) had a cost of 4.8 and returned Read More...
2 Comments

SQL Mag Article - Spotlight on SQL Server

Posted Monday, February 12, 2007 9:24 AM by michael.k.campbell
Just an FYI that my latest product review for SQL Server Magazine is in the February Edition. (My February edition only just BARELY showed up in the mail...). In this review I take a look at Quest Software's Spotlight on SQL Server 5.7 . It's a decent Read More...
0 Comments
Filed under: