Wednesday, May 16, 2007 - Posts

How many indexes do you have that aren't used?

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/How many indexes do you have that aren't used?
The new RSS feed is here

If you run this sql on a sql 2005 box then you will see which indexes aren't used in queries compared with the number of times they are updated.

select object_name(s.object_id) , *

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/How many indexes do you have that aren't used?

Presentation Skills A-Z

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Presentation Skills A-Z
The new RSS feed is here

Thanks to Donald for pointing out this great training onhow to do presentations.

My presentations will never be the same again

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Presentation Skills A-Z