I know you said the permissions are correct, but when backing up the server, the process doesn't your logins permissions. Instead it uses the permissions of the SQL Server service....

Every test I've seen indicates, except in well proven edge cases, you will always receive a benefit from clustered indexes, even on inserts. If you do a search on "Which...

The DTA works best, when it works at all, on entire loads. It's not terribly good at tuning individual queries. But if you have six hours worth of capture metrics...

The fact that it's intermittent suggests that it may have been running, but you were just missing the windows. Our situation was the same. It actually went away twice on...

Connections was in Vegas in the spring this year. I think that might be permanent. We'll see.

I've presented at both Connections & the PASS Summit. The sessions available at Connections...

I've hit similar issues in the past. What we found was that there was a system backup software that was monitoring the files and reading them as we created them....

Not in any way angry. Sorry if it...

Eugene Elutin (5/14/2012)

---

BTW, the only way to see the questions legally is to take the test. Any other way you're "seeing the questions" is illegal. We absolutely won't help you...

HowardW (5/14/2012)

---

OK, if it's a heap with no indexes, I'd fix the design rather than change parallelism settings.

You can find out if Session ID is unique at any given...

reks12 (5/14/2012)

---

thank you for your answer.

i have some page for that question but it ask me to download it

i want to see question with download it on my pc

that page...

Duran (5/14/2012)

---

Hello Howard,

The session table has no indexes. Its always functioned ok in the past, this problem appears to have come out of nowhere. I'm not sure how to find...

Duran (5/14/2012)

---

Ah, I was just reading about that in the link that Howard sent through, my server is indeed set to 5, so I shall change it, before I do...

You've got multiple full scans running on millions of rows. Until you make the query filter that data, performance is going to stink and there's almost nothing you can do...

Ah, I didn't spot the Exchange Event the first time through. This is a parallelism deadlock. Best solution in this case is to eliminate the parallelism. As a starting point,...

Dynamic Management Function? Part of the Dynamic Management Objects (DMOs) which include DMFs and DMVs (Dynamic Management Views).