Welcome to SqlAdvice Sign in | Join | Help

June 2007 - Posts

Great Article on Dynamic Sql usage with Sql Server 2005

This is probably the best explanation around on the different dynamic Sql approaches and the performance and benefits of each of them. If you are using Sql Server 2005 basically you should be using sp_executesql due to how it can cache the query plan
Posted by gstark | 0 Comments
Filed under: ,

Find Indexes that aren't Used in Sql Server 2005

One of the most important maintenance tasks for a database is making sure you have the right indexes. Sql Server 2005 makes this a lot easier than in the past by the creation of the dynamic management views. I recently went on a cleaning spree in our
Posted by gstark | 0 Comments