I recently requested "account is sensitive and cannot be delegated" for my SQL service accounts. Did I shoot myself in the foot and unintentionally break account delegation for the...

There hasn't been much explanation of why SPNs are important.

Given servers A and B in which the user has authenticated to server A with a domain account. ...

I'm in the process of implementing a solution so I'm not entirely confident I'm correct; however, I wanted to point out an issue with the SPN comment.

To my knowledge, the...

I'm on to something. I checked the agent log and it was complaining about a syntax error near "(". I ran the Profiler against the activity between the...

I would collect query plans when the view works and when it doesn't - then compare. There are times when the optimizer may not be choosing an index because...

What happens when you run the view query in the query analyzer. In other words, copy/paste the view definition in query analyzer and execute. What happens?

The SQL resource needs to be dependent upon the disk resources also (among other things). One trick I've used to trouble-shoot is to start the SQL instance via the...

I've had two cases in which default parallelism has resulted in poor performance. The first was in a DBREINDEX on an index with a datetime column and the other...

Check the OS event logs. Check the format of the USB drive and make sure it is not FAT or FAT32. I'm not sure what your problem is...