SQL
SQL To Check Space Taken Up By Each Table
This SQL for use with Microsoft SQL Server is a little better than the standard EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?'” SELECT t.NAME AS TableName, (sum(a.total_pages) ...
Read More
SQL Server Queries – Stripping Extra Characters from the End of a String
Yesterday while implementing a particularly difficult SQL report query, I came across the following question: Given a String ‘This is a test, this is a ...
Read More