MVDBA

move all indexes to a secondary file group

Move all (or chosen) standard indexes from your primary file group to a secondary file group (hopefully located on a seperate array)excludes clustered indexes, statistics and indexes associated with a primary keywhen you run it - set the debug to 1 to identify what the script will move, set it to 0 to actually perform […]

4.67 (3)

2006-06-19 (first published: )

5,097 reads

2005 readiness

A script to test your database for 2005 readiness.these features are as described by the SQL 2000 BPA, however this script will run on SL 6.5,7,2000Please note that this is not a guarantee of readiness, however it is an indication that there are issues you may have to resolve to run your databases in 2005

2006-06-02 (first published: )

780 reads

Blogs

What is a container anyway?

By

Recently there was a thread on Twitter which established that a lot of IT...

Comparing Execution Plans

By

When you run a query twice, and get dramatically different run times, your first...

What permissions do temp stored procedures use?

By

In a performance tuning class I recently took with Brent Ozar (b/t) he mentioned...

Read the latest Blogs

Forums

Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Optimize a stored procedure

By keneangbu

I have a stored procedure that is called multiple times to get all the...

Status Update 19 Jun 2019

By Steve Jones - SSC Editor

My apologies. I have completely slacked off here, but since the 17th of May,...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers