For the non catalog files you can use:

DBCC SHRINKFILE ( file_name , EMPTYFILE )

and later on

alter database xyz REMOVE FILE logical_file_name

Read BOL for more...

Oops, I missed the reconfigure statement.

That's why not all config options show up.

exec sp_configure 'show advanced options' , 1

reconfigure

exec sp_configure -- information (extended info activated please)

Can you post again...

well ... a function (datediff) can be avoided just by adding

one variable, calculating that and then have a straight comparisson

where clause.

This way chances of index usage will be...

Maybe.

If you add columns not null with an actual default value, rows will be rewritten, so in that case, yes , then the old columns will be gone.

Otherwise no because...

if you just want to kick everybody out user alter database

alter database xyz set single_user with rollback immediate;

restore database xyz

...

keep in mind NOT to place a "go" in between...

can you provide some more specific info ?

OS ? (+ sp)

SQL version + sp

exec sp_configure 'show advanced options' , 1

exec sp_configure -- information (extended info activated please)

This mainly to...

did you grant all sqlservers service accounts the needed folder authorities for the new location ?

Looking good.

Indeed the delete statement does not need the "*" :blush:

Think DRP: start with a full db backup for this operation !

Since this proc only has this single while loop...

DBA (3/10/2008)

---

hi my plan is to run this script once, delete 2 million rows out of 20 million, then create another query to do it every 3 minutes. so...

- that may be a good option if 2M is the majority or rows in your table.

- If not, you may want to use a while loop to just delete...

I'm sorry I've forgotten to mention just to put my code

right before the housekeeping section (last line) of Jeffs.

:blush:

-- put my code overhere

--===== Housekeeping

DROP TABLE #Tally

you could start with the using the new sql2005 except join

then unpivot the resultset

and then check for the differences.

remarks: datatypes will get converted to varchar(max)

(I did put max...

There is a very nice must read article bij Jeff Moden regarding this construct.

http://www.sqlservercentral.com/articles/Advanced+Querying/61716/

Like Chad Slagle explained, if you can, contact a sysadmin / serveradmin to run SQLUA for you, so SQLUA can provide you the most possible info.

And the example Jeff provided only handles a variable a couple of times.

I've added this bit, to get the data actualy in a couple of tables and

the effect only...