Is there a way to modify the procedure to be outside the database, perhapse another argument to select the database. I have a admin database that I store reports...

So far this is really nice and I can see how this can be helpful.

One suggestion possibly changing how the delay works as I found doing something like 60 seconds...

Here is my final solution, The one issue I had was it still repeated x number of rows so slapping a DISTINCT solved that. What does the XML do...

My two cents,

SQL is a big "it depends" environment which makes these questions a challenge. I am still fairly new to the SQL world so these are just my...

Good to know.

I need to set up a few tests in my environment to see the difference 🙂 Thats why I put a ? mark as I was unsure...

I was curious what approach would be used to fix this particular situation.

Not trying to hijack, I don't have anything this large :-D.

The overall goal is shortest amount...

OK,

A more experianced SQL DBA might be able to explain. I will be the first to say performance is not my area of experties (yet).

My general understanding...

Thank you, Unfortunatly I have to stick with SQL 2008 SP1 for the majority and maybe 1-2 R2 for specific approved applications. To many vendors do not mention R2...

Your sophisticated method for tape sounds like something similar to what we have. (NetBackup)

I totally would like to write to disk and have them back that up to what...

Quick question hopefully :).

Network team manages backups to tape and said tape system/application can not be setup to backup at specific times. It has some kind of queue system with...

Thank you, that does provide a good bit of information. I thought a spot on the 2008 build list would show at what point R2 was started. Like...

Where does R2 fit in this list? I thought if you were installing new systems you should be using R2. Although I have vendors that only go as...

I haven't successfully completed these steps but my suggestion would be

1. change server collation (this is important because you want tempdb matching db collation.)

3. database collation (should be...

Thanks Hugo. I remember that one now :). So much to know.

NOOOOOOOO the dreded