As for the old table, you were going to delete all but a million rows.  When you're sure the copy worked correctly, just drop the old table.

Also, decide the maximum...

I also read about using 'SWITCH' to map the data to the backup table, then insert the records back into the original table. Once the data dump is done,...

If you're going to remove 25% or more of the data from a HEAP or a Table (Clustered Index Present), the best thing to do all the way around is...

Good article.  Thanks for taking the time to write it up.

What I'd like to see is...

You have a database that has a partitioned table.  The partitioned table has 1 filegroup...

This is a classic problem with where to start counting.  It's compounded by the fact that when people generate the code for modification, it frequently adds a blank line above...

Let me understand this clearly... an "intern" had the privs to bring a production database down?

Seriously???

I think opinions are great for the same reasons as you, Grant.  Just not when it comes to things like code.  I've seen way too many things that turned out...

Oz-860645 was happy to come here for a quick answer but then says "Nevermind, I figured it out." and disappeared.

When I created the synonym I did it without the...

Sorry I'm lat on this thread and I may have missed it but no one is talking about the licensing costs of the SQL Server on the separate machine.

Also, did...

Especially when, IMHO, people use that nasty little word of "audit" like they did in this question.

This can be done by creating database level triggers and can seriously be enhanced in capturing not only what changed when but by who from where.

I can't offer the code...

i have a database with 400 stored porcedure , i need to optimise it , i found that tables are not having command index also.

like joins where ,group by...

Great question.  Proof that extra features always come at a price. 😀

It also means more page splits than normal due to "ExpAnsive" UPDATEs because of the typical extra 4 bytes...

Btw, I disagree with those who suggest to always specify the windowing range.  The default is ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.  Why repeat it?  The best part...

I know this is an old post but thought I'd add a little constructive feedback as to why folks may have graded it low.

If used for 100 rows, the data...