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
Archives