the following scripts helps in finding top 5 missing indexes using the new feature of DMV available in SQl Server 2005

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (2)

You rated this post out of 5. Change rating

2007-07-19 (first published: 2006-10-23)

5,361 reads

Updating all the indexes/statistics of a database

The below command will rebuild all indexes on a database.We need to run the below command in the context of each database that is of interest.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (2)

You rated this post out of 5. Change rating

2007-02-21 (first published: 2006-10-23)

1,217 reads

Blogs

All Spark Connect Posts Introduction There have been quite a few changes in the last...

ochisia – n. the fear that the role you once occupied in someone’s life...

This is a quick blog post, mainly so I have the code available if...

I'm using PowerQuery in Excel on my desktop. (Yeah, I know you can do...

Here's my data... I am trying to return total days in status for each...

Here's my data... I am trying to return total days in status for each...

When building statistics, there is the concept of density that refers to the duplicates in a table. How is this calculated?