Even though it may be a run-once query, performance should still be a consideration. If you are running this in a production environment, with millions of rows, and the...

Continuing with Homebrews comments - A backup and restore is NOT the way to go, unless the data is not important.

To roll out changes, you need to have change management...

Perfmon is one method to monitor Server performance for various SQL Server counters.

It's only 6:30am in Seattle - so probably hasn't been too much for the Kilt so far.

Not a fan of direct to tape backup solutions. I like to have my backups to disk and then a tape backup copy the bak file to tape from...

And now back to working on that sudoku solution from Lynn's earlier post (convert from oracle to SQL).

Interesting take. Consider that many of the people here...

I can't believe he had the gumption to actually say that Gail was whining.

WOW - He needed to look in the mirror while typing. Incredulous he is.

Some time ago there was a sudoku script posted here at SSC. I tested it and it ran correctly about 95% of the time.

SSC Sudoku[/url]

Trying to be at PASS mentally and it just isn't cutting it - every time I give a real good surge of mental effort to be there, I open my...

Aren't we all who are SQL DBA's? 😉

SSCrazy = Jeff

The system must recognize the san before the databases will become available.

You will need to put a dependency on the services such that sql server service does not attempt to...

1) This process is fine from the 10,000 ft level, not knowing the nitty gritty details.

2) Where is your Archive database? Same Server, different server? If different server,...

that is good to hear.