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...

there is also a doc (cannot recall right now) wich describes the 8060 pagelimit (fixed datatypes)

it states that if the rowlength for the fixed datatypes + varchar datatypes exceeds 8060...

- if only hardware is your concern, maybe you should opt for a number of named instances of sqlserver.

With WSRM you can "guarantee" a percentage of processor(s) to any single...

with SSIS you can use the script component !

that one supports vbs.