SQL Server Dedicated Support Engineer (PFE)
Translate This Page
Translate this page
Browse by Tags
Tagged Content List
Visualizing Index Fragmenation
We all probably realize that fragmentation can be a performance hindrance, especially for scanning operations. But, what does fragmentation really mean? What does it look like? I've been doing a lot of training for customers lately in terms of fragmentation so I wanted to do a blog post and dig a bit...
3 Dec 2012
Index Rebuild vs Reorganize: The transaction log edition
Recently a friend and fellow PFE Dave Levy ( Twitter / Blog ) and I were discussing a question someone posted in a forum. The question was in regards to database mirroring latency when a reorganization occurs. Dave mentioned that he has seen in the past that switching from performing a reorganization...
28 Sep 2012
The Joys of Filtered Indexes
A filtered index, introduced in SQL Server 2008, is a non-clustered index that contains only a subset of the number of rows contained in a table. Because there is a 1:1 ratio between the number of rows in a table and the number of rows in a regular non-clustered index, a filtered index can have performance...
27 Aug 2012
The Pains of Filtered Indexes
In a previous post I briefly went over how useful filtered indexes can be. Filtered indexes are a great feature that have numerous uses. However, like almost everything in computing, there are trade-offs, and filtered indexes are no exception. The challenge with filtered indexes is the decisions that...
27 Aug 2012
How to Parse DBCC MEMORYSTATUS via Powershell
SQL Server has many ways to dig deep into diagnosing memory related problems. Today it is common to use Dynamic Management Objects (views/functions) to expose a large portion of this information. However, some useful data isn't consumable by DMVs, so we must use DBCC MEMORYSTATUS to get what we need...
16 Aug 2012
Page 1 of 1 (5 items)
© 2014 Microsoft Corporation.
Privacy & Cookies