Kimberly L. Tripp

President, SQLskills.com

Kimberly L. Tripp has been working with SQL Server since 1990, and she’s worked as a consultant, trainer, speaker, and writer specializing in core SQL Server performance tuning and availability since 1995.

Posts by Kimberly L. Tripp

Apr 03, 2012

What about moving LOB data while keeping the table online?

Moving LOB data associated with a table isn't simple—even with the SQL Server 2012 ability to rebuild indexes that include LOB data as an online....More
illustration of data cube with red arrows indicating movement
Mar 21, 2012

What about moving LOB data?

There are actually a couple of ways to move LOB data associated with a table. Let's tackle moving LOB data using OFFLINE operations....More
table data on white piece of paper
Feb 27, 2012

How about Filtered Indexes instead of Partitioning?

Filtered indexes are an incredibly powerful feature (one of my favorites) so I don't want to dissuade you from using them. A table can be partitioned....More
computer keyboard Power Shift key
Feb 23, 2012

Did SQL Server eliminate any partitions?

If SQL Server is accessing a table where you don’t think it should, then check these things....More
Feb 09, 2012

Solutions to VLT concerns around statistics and maintenance!

Let's tackle why partitioned views can be a fantastic choice for partitioning large sets—even for new design....More
illustration of data with colorful numbers in background
Feb 02, 2012

Partitioned Tables v. Partitioned Views–Why are they even still around?

Partitioning is CRITICAL for VLT. What is VLT? It’s about as descriptive as VLDB and it means very large table. Most people speak of VLDBs (very....More
Nov 17, 2011

What's a good use for a UNIQUE filtered index?

Learn more about SQL Server UNIQUE filtered indexes and a minor limitation you'll need to know about....More
Nov 11, 2011

How many steps should the histogram have?

During the final phase of statistics creation (called Histogram consolidation), SQL Server goes through and looks at neighboring steps....More
Nov 06, 2011

Why can't SQL Server update statistics on the fly?

SQL Server stores statistics in 3 parts: the statistics header, the density vector and the histogram. The statistics header has basic (but very....More
Oct 13, 2011

Viewing the Last Updated Date for Statistics

In SQL Server 2005, they separated the IDs for column-level statistics from nonclustered index IDs and created a catalog view to see them: sys.stats....More

Sponsored Introduction Continue on to (or wait seconds) ×