Im going to use this place as a place to post up some generic DMV queries that I have developed.
Im a production DBA by day (and often nights), so all this code has been tested and used in high throughput production SQL Server 2005 environments.
Please feel free to point out improvements, certainly please tell me if they are wrong. Many of them were written urgently, on the spur of the moment and in anger.
If you can improve my SQL please go ahead and mail me any improvements.
Otherwise they are there, if you fancy using them or testing them, feel free, its a sharing exercise.