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. ...

You never know, but it just takes the right question or comment to spawn about six...

We have the same issue from Cognos. There's also a sp_prepare statement running before those queries that you're seeing. That's what sets the value for those integers you're seeing. Look...

Well, another problem that most people don't notice is that they change the bloody thing, regularly, and don't tell you that they did it. I've been using it as a...