RBarryYoung (5/5/2009)

---

Alvin Ramard (5/5/2009)

---

David Burrows (5/5/2009)

---

Lucky for the OP that is was not Jeff, Pork Chops...

You're way too nice Lynn. I would've walked away. If I need people yelling at me when I'm trying to help, I can go home & help the kids with...

Luke L (5/5/2009)

---

Pretty much the same story here. I was in Music school studying audio for film (had some strange desire to be a folley artist), then joined the...

Just a question, why have the governor in place at all if you're going to remove the limits as soon as you hit them?

To know what the DTA looks for inside it's code, you need to talk to someone at Microsoft. There's very little in the documentation (available here, just so you have...

I'm a film school drop out. No degree, at all.

However, to get past the HR check boxes, I do list the school I attended. I just don't list a degree....

You might be able to get that by using a trace and capturing the cache miss event and then pairing that with the sp or rpc starting events to see...

There's nothing that will automatically suggest an indexed view. They really depend on what you're doing with the data. There isn't a set formula for their use, although there are...

The Inside SQL Server series, specifically the book on performance tuning could help you. I'd like to recommend my book as well, in the link below.

Just to pile on a bit & reinforce what everone else said, when possible, avoid table valued functions like the plague. They are serious performance killers because SQL Server cannot...

Bob Hovious (5/4/2009)

---

Gail,

Warren Zevon was a singer/songwriter who died a few years ago. One of his greatest hits was a song called "Werewolves of London", which I...

You also performed a service linking to Connect. Hopefully this'll get some more votes.

Great article Roy. Well written and informative.

I was kind of hoping you had a fix to the problem with removing TDE though. 😀

Florian Reischl (5/3/2009)

---

Sorry for disturbing the silence of The Thread but I have to get this off my chest...

I HATE EXCEL!! I'm about to finish my first article and want...

Dave Smith (5/1/2009)

---

I heard about his death. I loved Crash and the Atrocity Exhibition. I also read the REsearch books that featured his interviews and short fiction. ...