... or try the following (don't use * though, not a good practice - use named list instead):

Give that a try. Play...

I'll confess I'm addicted to this site...

Every time I get an email notification on a new posting, it's as if it goes straight to my veins! :w00t:

Also, it may be that Max. degree of parallelism (MAXDOP) is set to an excessively high value on your instance.

Run the following query to get the top 10 wait types...

Since DTA stops unexpectedly, run the following statement to ensure there are no hypothetical indexes left behind:

Drop any such...

I think the DTA still needs a lot of work on behalf of the SQL Server dev team.

I have only been able to get it to work on individual queries...

Provided your instance has been running long enough for adequate stats - say a few days - the following query will yield the top 10 most CPU-intensive queries since last...

GilaMonster (3/27/2008)

---

284MB for the plan cache on a server with 16 GB is nothing. I really wouldn't worry.

What are your server's max and min memory settings? Anything else on the...

Adam Haines (3/27/2008)

---

Simple recovery does not mean the log is not used. If transaction were not logged in the t-log how would you rollback transactions? This is why...

I don't think I can afford him... 😉

rbarryyoung (3/26/2008)

---

Marios Philippopoulos (3/24/2008)

---

Good luck. Make sure that you've got...

colin Leversuch-Roberts (3/26/2008)

---

if your proc call is not the same case as your proc def then you'll get a cache miss event. What's more worrying is that in a highly...

Tim Mitchell (3/25/2008)

---

I don't think you can do what you describe if you only use one control. Controls are rendered as a whole rather than character-by-character.

Is there any reason...

There's a great document which details how to configure and troubleshoot Kerberos delegation related problems here (it's essential reading for CRM 3.0 configurations where all the tiers are on separate...

...pages 345 ff 🙂

I have the exact same issue - some more info on the file location would be appreciated