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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

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

5,367 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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

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

1,226 reads

Blogs

I hosted this month, but I decided to put my own entry in as...

I get asked a lot about why or how I began working with databases...

Earlier this year I visited a customer that was using the Redgate Monitor webhook...

Comments posted to this topic are about the item Implementing PostgreSQL with Python for...

Comments posted to this topic are about the item Identify a Slipstream Installation

Comments posted to this topic are about the item Internal Staff Growth, which is...

I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?