dmvs get cleared when the sql service restarts. Some events will clear dmvs and some dmvs manage themselves to minimise any contention; some dmvs will defer if resource is low.

Usually...

I'm not sure about the execute as, but basically the AD group you create the server login for should conatin as a member the user you wish to have permissions.

You...

As far as I can see you've done this correctly. To use as an example I'll describe how i give permissions to non dev users on a test database.

I have...

it sounds as if your box is just running slow - I'd suggest a general health check for any config chnages that might have been missed. You might want to...

do you mean the SIDs don't match? If so search technet/msdn for methods to move logins from one server to another. I suspect most DBAs have different ways...

yeah well sort of; essentially the new index is built in the background leaving the original index available for queries; once it has finished it is swopped in against the...

hmm tricky - I don't have cross domain linked servers. I do wonder if named pipes is an issue - I normally disable the named pipes library as a matter...

very rarely use activity monitor, but suggest you fire up Perfmon and see if the sql counters are available. Perfmon counters sometimes don't load, or maybe don't get installed somehow,...

I can't say I'd ever noticed this, I suppose because I often work with the o/s I'd always go to the windows event logs in windows, not sql server. All...

It's interesting to read how different people approach the same thing. My first port of call is nearly always the query plan. I do wonder if we're a bit at...

SSPI errors are a pain, I think the sql protocols team at ms blogged about this - find their blog to see if it helps. I assume you changed service...

I do this, but it's not done for you in SQL Server. I capture mdf,ldf and data sizes every day - from this I produce reports on database growth and...

Hi Adam - no not used your proc and I was in no way suggesting that it shouldn't be used. I was just observing that usually in my scenario I...

ah you've never met my development team! Only they could could generate 18 million page reads looking a person's name up < grin >

nothing wrong with online index rebuilds as long as your system is quick, some types of indexes cannot be built online so do be careful. .. I was remarking on...