Tag Archives: DMV

Who’s active on SQL 2000

Yes yes yes I *know* we are currently on SQL 2012 but just hear me out for a second… I think I am probably one of the only people on the planet who has not (yet) used Adam Machanic’s (blog|twitter) … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , , , | 5 Comments

What are the impersonation rights for my database users?

From time to time I get thrown the odd request to provide various bits of information from the SQL Server environment and most recently I was asked about a group of databases that required migrating to another instance. For some … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , , , , ,

Where to go for your Wait Stat information

Fairly recently I was talking with a rather talented SQL Specialist internally at Microsoft and was asked the question by him as to where I get my Wait Stat information from. Query tuning isn’t really something I currently am required … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , , ,