Brandie Tarvin (4/6/2011)

---

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here>...

sqldba_icon (4/5/2011)

---

GilaMonster (1/18/2011)

---

Lee Forst (1/18/2011)

---

Grant, another question if I may. What happens in the case of a proc that has conditional branching? For example, the proc has a...

Jeffrey Williams-493691 (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Can you try using restricted user instead of single user? I've seen applications that constantly refresh their connection so they can squeek in before you start...

What version of 2005 are you running. Apparently if you're not up to at least Sp2 this won't work.

Yeah, local variables is a mechnism for defeating some forms of parameter sniffing. What it means is, instead of using a specific value to arrive at an execution plan, it'll...

It sounds like you're experiencing what is known as bad parameter sniffing. There are several ways to fix this before you get to plan forcing. That should be the last...

Lots can go wrong. Upgrading away from 2000 can be quite dangerous. It really depends on what kind of code was written against the 2000 server and how it was...

Rich-403221 (4/5/2011)

---

Okay, let me add a little confusion here. There are really 2 types of fragmentation that can occur in a heap - internal fragmentation and external fragmentation. The internal...

I don't know that there is a single best practice, but in general I would advocate for having a service account for SQL Server and have the jobs owned by...

Stefan Krzywicki (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here>...

Lynn Pettis (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here>...

Brandie Tarvin (4/5/2011)

---

Grant Fritchey (4/5/2011)

---

Whoa! What? You're a youngster and you don't live in a cave, how is it that an old <insert inappropriate term here> like myself knows what...

It's not a trace. It's a traceflag. Totally different issue. No. It won't affect performance. You need it to understand deadlocks, otherwise you're just guessing. Here's the BOL entry on...

Brandie Tarvin (4/5/2011)

---

GSquared (4/5/2011)

---

Jack Corbett (4/4/2011)

---

Definitely depends on region AND size of the...

With just that information, you can't. You need to have trace flag 1222 enabled and then a full set of information about the deadlock, including both the victim and the...