I seem to be the harbinger of doom.

Terry Pratchett has died.[/url]

Proving it will be fine is easy. Show that the app works before and after the change. But, you want to prove a benefit. To do that, I'd show the...

Backup adds load to the server, but it doesn't lock things and cause blocking. The added load could be causing the timeouts, but it's hard to say without more information....

Well, let me know if you want drill down on this. Happy to try to help.

I like Jason's description. It's for undoing a situation.

So, it sounds like you see a lot of code of the variety like this:

BEGIN TRAN

UPDATE TableA

SET ColA = 42

WHERE ColB =...

jasona.work (3/11/2015)

---

Katerine459 (3/11/2015)

---

Thanks, all, for the recommendations... I'll be sure to check those out when I have a chance.

If a stairway ever does get created, I just wanted to give...

Generally speaking, SQL Server didn't do well in kindergarten. It doesn't play at all well with others.

If you already have an isolated production server and you're considering consolidating this other...

I can give an example of a "routine" shrink, but it's not on a production box.

We would take our production database and restore it to a staging machine. There, we'd...

Here's an article[/url] I wrote on the various mechanisms and what each one does for you. The best is what Gail says, restore the database.

It's probably the load on the server, the queries, the database design, the statistics, the indexes, etc., that are leading to high CPU use.

I'm with Gail, patch the server,yes. But...

If you are going to try to capture events on a 24/7 basis, you might want to use extended events instead of trace. They have less impact on the server....

I just did a quick couple of searches on Simple-Talk, and I don't see any. I've bugged the editors to get you one. In the mean time, understanding how the...

The fragmentation problem of database shrink events is not to the indexes. That type of fragmentation is easily fixed. It's fragmentation of the file on disk. That's different and not...

I've not seen a 2014 BPA. According to this thread on MSDN, no, the 2012 version won't work.

xsevensinzx (3/10/2015)

---

Yeah, it's doing a seek. It wasn't at first. I threw in a table hint to point to the clustered index, which shaved off some time by 20 seconds...