Kimberly L. Tripp


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 in SQL Server Questions Answered view all

04/03/2012 - 4:21pm

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
03/21/2012 - 7:26pm

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
02/27/2012 - 9:45am

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
02/23/2012 - 5:20pm

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
02/09/2012 - 12:49pm

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
02/02/2012 - 7:23pm

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
11/17/2011 - 8:01pm

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
11/11/2011 - 12:42pm

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
11/06/2011 - 4:41pm

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
10/13/2011 - 1:57pm

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
What's SQL Server Questions Answered?

Practical tips and answers to many of your questions about SQL Server including database management and performance issues.

Sponsored Introduction Continue on to (or wait seconds) ×