Sqlserver

System query

Show all tables sizes

SELECT s.Name AS SchemaName, t.NAME AS TableName, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB
 FROM sys.tables t
INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id
 LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id
WHERE t.type_desc = 'USER_TABLE' 
GROUP BY t.Name, s.Name, p.rows
ORDER BY TotalSpaceMB DESC, t.Name

Links

• SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQL Authority with Pinal Dave
• SQL Server 2005 commands
• GRANT (Transact-SQL)
• SQL Server Sequence Number - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs
• SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice « Journey to SQL Authority with Pinal Dave
• Data Points: Exploring SQL Server Triggers