I'm with Paul. I've done it both ways successfully, but the only way that splitting the database really worked well was if the structure was changed in the archive system...

Jan Van der Eecken (9/13/2011)

---

Steve, please enlighten me,...

It could be bad parameter sniffing (differentiated because parameter sniffing is going on constantly and helps you). You need to get a copy of the execution plan when the query...

Read my book. It's down there in my signature.

In general, a correlated sub-query in the SELECT list can lead to poor performance. You're usually better off finding some way to move that down into the FROM clause.

If...

Of the year? I think I'd put it down to of the decade, but that's not what the contest was. Regardless, congratulations Jeff. You earned it! Can't wait for the...

A single file also means if the file gets corrupted, you lose one backup, not all of them.

Jpotucek (9/13/2011)

---

Thank you for all the replies.

I AM doing regular Databases backups Full nightly Database backups and Transaction Log backups where appropriate and depending on the SLA with the...

Piling on a bit, because it's a point worth making.

Most backup products are not aware of the fact that SQL Server has this pesky little function called a transaction. So,...

Bob Fazio (9/12/2011)

---

There is also a patch we are strongly looking at. http://support.microsoft.com/default.aspx?scid=kb;EN-US;976700

The reason why we are leaning towards the patch, is because I think everyone agrees, one bad...

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the topic they...

The performance counters would be primarily waits and queues, but you need to combine perfmon with query behavior. You can't just measure one or just the other. What's the page...

Since this is a reporting system, you might not want to go as high with the cost threshold, 25-30, which means your average cost of 35 might still get parallelism.

CXPacket...

Ninja's_RGR'us (9/12/2011)

---

I'd actually say it's worse, especially in a multi db environement.

Imagine losing 1 out of 100 dbs. It's annoying to very problematic, but if ALL of them go...

There are some free books out there. But,...