Monthly Archives: May 2014

Some Useful SQL queries

I have compiled below some SQL queries that I have been using regularly. I can’t take credit for writing all of them, though. /*get size and free space in a database*/ SELECT DB_NAME() AS DbName, name AS FileName, size/128.0 AS … Continue reading

Posted in Microsoft SQL Server | Tagged , | Leave a comment