thanks Gail, i had a look at that. Re run the script but this time play around with the fill factor...

AFAIK the only time its really valid to use a select * is inside a correlated query, dont know if anybody else can add to or confirm this

do you mean reorganise vs drop and create rather than rebuild vs drop and create

wow, never tested it Gail. How would it account for a different fill factor though?

Agree with the last point though, dont shrink!

if you are going to shrink, at least do it after the index rebuild as pages will be moved around. If you specified a fill factor of 50 for instance...

pound for pound, i have found it quicker to detach copy then re attach databases rather than backup and restore. Also dont forget the microsoft scripts to export your logins...

how many servers\databases are we talking?

how many characters is the servername currently?

is the SQL server a member server or stand alone server

could it be that someone has configured an application\web site to use the SA account? either way assign an obscure password to the account and then disable it. Use the...

set the recovery model to "bulk logged" during the purge and change back to simple after you have finished deleting data

you would be wise to furnish sql server with more memory rather than CPU. High CPU count will raise the software costs too 😉

for SQL2000 try this, it returns any objects not owned by sys or dbo just change it to look for your login (instead of excluding). To catch all DB's wrap...

exactly, BTW also forgot to mention that sa login is also disabled on our sql servers.

even under virtualisation 64bit isnt necessarily the defacto platform

if you plan on using perfom there are a set of key counters to look at, what do you plan to use?