April 2007 - Posts

• Dynamic management function query to view index usage

  Last week, I presented a query to view I/O pressure , and (to me) more usefully, look at it in a slice of time, like when doing a performance test. Here is a a very similar solution for index usage using the sys.dm_db_index_usage_stats dynamic management Read More... Posted Sunday, April 15, 2007 2:58 PM by drsql | 2 Comments

• Dynamic management function query to view disk I/O pressure

  The sys.dm_io_virtual_file_stats dynamic management function returns I/O statistics for data and log files [MDF and LDF file], with two parameters, one for database_id and another for the file_id. This function will help you to identify I/O file level. Read More... Posted Friday, April 06, 2007 8:32 PM by drsql | 1 Comments

• SQL Server Search Macro (plus build your own directed search!)

  Microsoft has built a little site for searching the books online on the web (which gives you links that are more readily shared with others): http://search.live.com/macros/sql_server_user_education/booksonline That is nice, but what is nicer is that you Read More... Posted Tuesday, April 03, 2007 7:03 PM by drsql | 1 Comments Filed under: SQL Server, Search