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

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

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

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

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

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

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

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

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

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

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) ×