A great fan of Joe Celko smarties.

Won't use "great solution" in production.

Agree the "Select *" will take few DBA years to be weeded out.

Nice generic statement, just replace the table name.

Thks, will end up as another A4 poster on the cubicle wall

TRUNCATE also resets the seed.

How many records. Very interesting question.

Suppose you would have read BOL: "Logged and Minimally Logged Bulk Copy Operations"

Maybe compare with BCP alone versus BCP out and...

Could not reproduce on SQL 2000.

Would you mind to try the following :

Create Table TTest(AA int,jnk varchar(10),BB int,CC float,DD tinyint,EE real,jnkII char(10))

GO

declare @NumericColsAdded varchar(8000),

...

Agree with mccork.

Try a Select 'Before Insert' and Select 'After Insert' after the actual Insert.

Alternatively step through proc.

I think remove "WITH FILE = 2" from the second restore

BOL: FILE = { file_number | @file_number }Identifies the backup set to be restored.

Assumption you backuped...

What about the crdate

Select * from Master..SysDatabases

Where CRDate>=DateAdd(d,-1,GetDate())

I think changing "(SELECT DISTINCT clientStoreNum FROM tblStore Where clientId =@clientid)" from "(SELECT DISTINCT clientStoreNum FROM tblStore)" should do it

How about the database reverse engineering feature of some products like Visio?

Declare @Month INT

Select @Month=5

Select Datename(Month,'2001-'+Cast(@Month as Varchar(2))+'-1')

"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint" -S lene -D Northwind -CkDB -CkCat -Rpt C:\Northwind.rpt

if errorlevel 1 echo ERROR

if errorlevel 0 echo OK

"C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlmaint" -S lene -D MSDB -CkDB...

Is the query plain vanilla inner join, etc. no group by, order by or aggregates etc.

I'll go with the upto date indexes first(a5xo3z1).

On average, what will be the number...

Previous posters said it all.

Maybe schedule deletes for 2:00 am (low activity).