Browse by Tags

• /faster
• Fundamentals
• Indexes
• SQL Server
• T-SQL

sys.dm_db_index_operational_stats: Kick Your Assumptions: Part 1

A two-part tale in which your humble correspondent interrogates databases & Very Smart Persons (VSPs), & is forced to kick his ass- umptions regarding a popular DMF. Executive Summary Documentation for the DMF sys.dm_db_index_operational_stats Read More...

Posted 03 August 09 09:17 by Jimmy May | 0 Comments   
Filed under Best Practices, Fundamentals, SQL Server, /faster, DMOs/DMFs/DMVs, T-SQL, Indexes

Search

This Blog

• Home
• Email

Tags

• /faster
• Architecture
• Best Practices
• Career
• CPU
• Discipline
• Disk I/O
• Disk Partition Alignment
• DMOs/DMFs/DMVs
• Effectiveness
• Engineering Discipline
• Fundamentals
• Geekly
• Humor
• Hyper-V
• Indexes
• L'Chaim!
• Me
• Memory
• Miscellaneous
• News
• Office Productivity
• Outlook
• PerfMon
• Performance
• Personal Productivity
• Productivity
• Replication
• Scalability
• Speaking
• SQL CAT
• SQL Server
• SQLIOSim
• Table Partitioning
• Tools
• Training
• T-SQL
• VSTS
• Wait Stats
• xperf/ETW/WPA/WPT

Archives

• November 2009 (2)
• October 2009 (1)
• September 2009 (4)
• August 2009 (1)
• May 2009 (5)
• April 2009 (5)
• March 2009 (9)
• February 2009 (3)
• January 2009 (1)
• December 2008 (4)
• November 2008 (3)
• October 2008 (4)
• September 2008 (2)
• June 2008 (1)

Best of Blog

• SQL Server: 4-Step Performance Troubleshooting Methodology--Introduction
• Drum Roll, Please...The Debut of The SQL DMV All-Stars Dream Team!
• PerfMon Objects, Counters, Thresholds, & Utilities for SQL Server
• Disk Partition Alignment (Sector Alignment) for SQL Server: Part 1: Slide Deck
• Disk Partition Alignment (Sector Alignment) for SQL Server: Part 4: Essentials (Cheat Sheet)
• Disk Partition Alignment (Sector Alignment): Make the Case: Save Hundreds of Thousands of Dollars

Speaking

• ITT 2008 Commencement
• PASS 2008
• PASS 2009

Syndication

• RSS 2.0
• Atom 1.0