Ok, so what metrics/stats/info do you have for the period in question?

What monitoring did you have running at the time it happened?

Additionally, the only time that mirroring is supported between different versions is as part of a rolling upgrade. To be honest it makes no sense any other time, because you...

Jack Corbett (10/21/2014)

---

Can one of the corruption guru's take a look at this post, http://www.sqlservercentral.com/Forums/Topic1627263-2799-1.aspx, and help the guy out. I asked a couple of questions, but...

Rather use two parameters. It's one of those good coding practices, a parameter should be one thing only.

Not possible

A restore recreates the database exactly as it was at the time of the backup. You'll have to do that in two parts, restore first, then split it up...

I do so hope he...

TheSQLGuru (10/20/2014)

---

Hmm, brain cloud this morning. So is there a case where multi-column stats WILL allow proper row estimation (OPTION (RECOMPILE), dynamic sql, etc)? And can't the second+...

It's a lot of work. It'll work, except for PRIMARY. It will leave test different to prod though.

How big is the database now? You said it was 50MB before, what is it now?

What does the query actually do?

How many rows are in the table now? How...

Ok, you don't need to get the IDs back. What you want to do is send parent and child data to the stored proc (table-type parameters are fine for this),...

Shrink, then rebuild. As long as you don't shrink to 0% empty space, you shouldn't see too much of a file growth.

Doesn't work well, the histograms...

Sending multiple rows to the procedure's a great idea, but not if you then sit and loop through those rows one by one and insert them. You've done nothing to...

Wrap the COMMIT transaction in a check to see whether or not there are any open transactions. At the moment, if an error occurs and the catch block runs, SQL...