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 again I take for [...]
Posts Tagged ‘DMV’
Another Reason SQL 2000 should just go away! :)
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 this (listed [...]
