No, nor I. Most of the stuff in the error log is pretty self-explanatory and not usually vague. But, if you are looking for a good getting started book on...

I don't think there is a single right answer to this. I very much believe that you should NOT use the administrative accounts as owners of the databases or for...

GilaMonster (1/10/2014)

---

I'm sure I've seen that on gaming...

You have processes that are doing things that use tempdb such as sorts or index rebuilds or something else. You need to identify these processes, figure out how long it's...

It's a tough problem to solve. There are two sets of tools that could help you out. Microsoft has a deployment tool called SQL Server Data Tools (SSDT). You can...

Sure. You can use SQL Agent to call the command line utility of Data Compare. You can then have that output to a report, generate a script or even update...

ChrisM@Work (1/10/2014)

---

Grant Fritchey (1/10/2014)

---

Jeff Moden (1/8/2014)

---

rodjkidd (1/8/2014)

---

Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and wind seems to be the story of...

Jeff Moden (1/8/2014)

---

rodjkidd (1/8/2014)

---

Weather update, as Grant has discovered it gets dark here very quickly, that and the rain and wind seems to be the story of the week in...

Just a data insert alone will not affect plan cache (it sure can affect the rest of the cache). But, the update in statistics can affect recompiles. Maybe that's what...

You can't really fragment an index with modifying the data. Don't test stuff in production.

Sounds like a limit imposed by the operating system then.

Hmmm...

I would suspect the statistics are going out of date and leading to a bad plan which is locking everything up, but that's a guess. There's not quite enough information...

Are you on the latest service pack and cumulative update? I still don't have time to really dig into this, but thinking about the missing statistics, I'm wondering if you're...

I'm overseas currently. I'm going to have to get back to you on the details here.

What David said is accurate. The entire cost for the plan is stored in the first operator, SELECT/UPDATE/DELETE/INSERT.