You have to know that with dynamic queries, every single change to the string that defines the query means you get a new execution plan, unless you use parameterized queries...

In addition to limiting the indexes that you perform maintenance on based on fragmentation, I'd also limit based on the number of pages. Defragging or rebuilding an index less than...

One of the keys to indexing is to watch the leading edge, the first column. You really need to avoid, as much as humanly possible (I'd say eliminate, but that's...

Roy Ernest (11/3/2010)

---

Just wanted to give an update. Things are much better now. It did not rain much. The sky is still totally covered with cloud. Still raining but not...

GilaMonster (11/3/2010)

---

Grant Fritchey (11/3/2010)

---

Just sent out a beg on twitter too. I think we can put you over the top if we keep pushing. I'd just like to win my...

GilaMonster (11/3/2010)

---

and I have 2 computers and...

GilaMonster (11/3/2010)

---

BrainDonor (11/3/2010)

---

I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down...

BrainDonor (11/3/2010)

---

I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down and...

Kit G (11/2/2010)

---

Roy Ernest (11/2/2010)

---

Tail of Tropical Storm Tomas hit Curacao (My island) leaving 3 people dead, lots material damage, 280 mm of rain and lightning. We are expecting more...

CirquedeSQLeil (11/2/2010)

---

GilaMonster (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is...

GilaMonster (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in...

Jeff Moden (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is...

Fixed it on the post.

Alvin Ramard (11/2/2010)

---

Grant Fritchey (11/2/2010)

---

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is...

For those who don't know, several of our locals are up for an award at SQLServerPedia for blog posts done over the last year. Gail is in three different categories...