Source control and automation are your friends. You can go in the direction you're trying to go, but not through the use of a single giant script. You'll need lots...

niclas-1082356 (1/3/2012)

---

Grant Fritchey (1/3/2012)

---

chandan_jha18 (1/3/2012)

---

Jeff Moden (1/3/2012)

---

Dev (1/3/2012)

---

chandan_jha18 (1/3/2012)

---

Dev (1/3/2012)

---

chandan_jha18 (1/3/2012)

---

Jeff Moden (1/3/2012)

---

Actually, it's "expected" behaviour. An INSERT will "touch" on all indexes. An...

niclas-1082356 (1/3/2012)

---

Dev (1/3/2012)

---

It might not be true. How did you measure...

The issue I have with the Kindle and technical books/white papers is the same thing I have with actual paper, I can't copy & paste really quickly into a query...

The biggest question you have to answer is, how much data can the business afford to lose. Get a very solid answer to that question, and then you can build...

You could try print statements in the script and proc and then capture the output from the job to see what you get to.

Think about it like this, you don't need three columns, you have three potential pieces of information for a unique relationship between a student and a course. That might help...

chandan_jha18 (1/3/2012)

---

Jeff Moden (1/3/2012)

---

Dev (1/3/2012)

---

chandan_jha18 (1/3/2012)

---

Dev (1/3/2012)

---

chandan_jha18 (1/3/2012)

---

Jeff Moden (1/3/2012)

---

Actually, it's "expected" behaviour. An INSERT will "touch" on all indexes. An UPDATE might not...

You've got a query that is looping reads on a table waiting for inserts... You might just be blocking one process or the other. I'm not sure that's the approach...

I suspect there are a bunch of tuning opportunities in the query, including the possibility of adding indexes. Knowing nothing else about the situation the one thing I'd look at...

I'm not so sure I'd be too quick to dismiss the issue as SQL Server. It sounds like it could be bad parameter sniffing. Especially since clearing the procedure cache...

You may think there's enough space, but SCCM disagrees, although it may be a default message meaning "something went wrong." Double check the server you're running it on to see...

Stefan Krzywicki (12/29/2011)

---

I can't even get them to buy...

Stefan Krzywicki (12/29/2011)

---

GSquared (12/29/2011)

---

Dev (12/29/2011)

---

I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a nice learning opportunity that I missed. However the...

GilaMonster (12/29/2011)

---

Grant Fritchey (12/27/2011)

---

Based on the fact that we can't get people to run good sets of backups despite Umptymillion articles, blog posts, presentations, webcasts and screaming lightning talks, I...