OK maybe not “harder” but I just found a DMV that I didn’t know existed that is going to help me make “better, faster, stronger” an old way of doing things. I wrote a blog post back in 2009 called: Check SQL Server Agent Status on all SQL Servers This scripted used the sysprocesses table [...]
Posts Tagged ‘DMV’
Another Reason SQL 2000 should just go away! :)
Quick without looking it up… what does this script do: SELECT * FROM dbo.sysfiles WHERE (status & 0×40) <> 0 So if you’re like me and don’t have all the bit compares memorized for all the tables you probably didn’t know that this is how (in SQL 2000) you would query the current database to find all the transaction log files. Every now and [...]
SQL 2008 – Persisted SKU Features DMV
In my continuing effort to bring forth the lesser known new features in SQL Server 2008 I give to you: sys.dm_db_persisted_sku_features This is great. This new DMV gives you a nice quick view of the features that your database uses that are restricted to only Enterprise or Developer editions of SQL Server. Some examples of [...]
