Browse by Tags

• SQL Server
• T-SQL

• 2008: Rebuilding a Heap

  In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy. You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do. They have added to the ALTER TABLE command Read More... Posted Wednesday, February 27, 2008 2:10 PM from Louis Davidson | (Comments Off) Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_exec_sql_text

  This dynamic management object returns the SQL that was saved when a query was executed. This is a very exciting and useful thing to have, as there are dynamic management views that you will be able to use to get statistics for a query, as well as the Read More... Posted Thursday, October 04, 2007 2:53 PM from Louis Davidson | (Comments Off) Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_index_operational_stats

  This object provides very useful stats on how many times an index has been used, locked, waited on, etc. An index in this context can mean several things: a clustered index, heap, index, or a partition of either of these. The grain of the function is Read More... Posted Monday, August 27, 2007 7:12 AM from Louis Davidson | (Comments Off) Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_index_usage_stats

  This object gives statistics on how an index has been used to resolve queries. Most importantly it tells you the number of times a query was used to find a single row ( user_seeks ), a range of values, or to resolve a non-unique query ( user_scans ), Read More... Posted Monday, July 23, 2007 1:45 PM from Louis Davidson | (Comments Off) Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_file_space_usage

  Give space usage of objects in tempdb (most likely this will be extended to more than just tempdb in a future edition of SQL Server.) Can be used to see how and why space is being used in Tempdb, on a file by file basis. Type: View Data: temporal, reflects Read More... Posted Sunday, July 15, 2007 6:35 AM from Louis Davidson | (Comments Off) Filed under: SQL Server, T-SQL, Dynamic Management Objects

• sys.dm_db_partition_stats

  For the current database, gives you space oriented statistics for each partition of indexes (even if you only have one partion), like row count, page counts, etc. Resembles the sysindexes in previous versions of SQL Server, with more information. Type: Read More... Posted Thursday, July 12, 2007 12:41 PM from Louis Davidson | (Comments Off) Filed under: SQL Server, T-SQL, Dynamic Management Objects