Kit G (8/11/2009)

---

Well, the remake might get the specials correct (the bugs, suits and...

I am not witty, but here's my pass:

No Longer Single Double

GilaMonster (8/10/2009)

---

Chad Crawford (8/10/2009)

---

I don't think any of you have to worry about too much. English is my first and pretty much only language, but I still don't dare...

I do want to raise one point that was mentioned earlier. In 130 or so comments, where is the author? I think he put forward an honest best faith effort...

GilaMonster (8/10/2009)

---

timothyawiseman (8/10/2009)

---

I am not clear on if temp tables generate better execution plans than table variables. I have not formally tested it, but intuitively I would expect the...

timothyawiseman (8/10/2009)

---

GSquared (8/10/2009)

---

Have to sort of disagree with you on this one. Temp tables cause statement recompiles in 2005/8, and proc recompiles in 2000, but even those are often/usually...

GilaMonster (8/10/2009)

---

Well, they are a cure for cursors....

I agree with Paul. Split up the machine and you should be good to go. However, it's worth noting, the "good" instance might not be quite so good any more.

It was a good faith effort, but based on the "Oh boy, I gave this 5 stars, my life is better" responses that were in the discussion in a few...

I saw Gail's answers and I think she hit the ones I was going to hit, but I'm feeling the need to pile on a bit.

#8: KEEPFIXED PLAN can...

That's tough. But in terms of performance, you could still use a TOP with an ORDER BY and arrive at one row, if somewhat randomly. It usually performs better,...

Well, it's possible, if you're backing up to the same place every time, that your backups are aggregating within a single file. If so, when you run a restore, you...

Agent alerts is the easy way. Why have something polling the server when it's already built in.

Or how about setting up a server side trace to capture deadlock graphs. That will give you a lot more information. Besides, what are you going to do about a...

It is possible to create a UDF with a unique index or primary key constraint, but it won't generate statistics and therefor won't be useful to you for querying. You'll...