By Kimberly L. Tripp, 04/03/2012
In my last post, I wrote about moving LOB data using OFFLINE operations: What about moving LOB data? It all started with the following question/discussion… QUESTION: How can I ...
By Kimberly L. Tripp, 03/21/2012
Background: In our Internals and Performance Immersion Event (IE1) in Atlanta this past December (12/2011), a fellow SQL MVP (Aaron Nelson, @SQLvariant) started a discussion about ...
By Kimberly L. Tripp, 02/27/2012
Question: I've been reading your Q&As on partitioned tables and views and I'm wondering how filtered indexes fit in. Couldn't you get some of the same benefits of partitioning by ...
By Kimberly L. Tripp, 02/23/2012
Question: I'm reading with interest your answer(s) to Partitioned Views vs. Partitioned Tables in your Q&A. My question is how can I prove to myself I have everything configured ...
By Kimberly L. Tripp, 02/09/2012
Question: Partitioned tables were the new shiny feature in SQL Server 2005 – why are partitioned views even still available? Are there any benefits that they provide? Answer: In ...
By Kimberly L. Tripp, 02/02/2012
Question: Partitioned tables were the new shiny feature in SQL Server 2005 – why are partitioned views even still available? Are there any benefits that they provide? Answer: ...
By Kimberly L. Tripp, 11/17/2011
Question: I get the idea of filtered indexes but I can’t see a good use to a UNIQUE filtered index? When would that be beneficial? Answer: Actually, I’ve got a fairly ...
By Kimberly L. Tripp, 11/11/2011
Question: I know that the histogram can have a maximum of 201 steps (as per your Why can’t SQL Server update statistics on the fly? article last week). But some statistics have ...
By Kimberly L. Tripp, 11/06/2011
This week's question comes from one of the attendees of SQLConnections who asked this during our "Follow the Rabbit - Q&A" session with which Paul and I always end the conference. ...
By Kimberly L. Tripp, 10/13/2011
Question: You talked about when statistics get updated last week. How can I see when the statistics were last updated? Answer: Actually, this question is much more interesting ...
By Kimberly L. Tripp, 10/07/2011
Question: Recently I noticed an option with CREATE/ALTER INDEX called STATISTICS_NORECOMPUTE? I'm not sure I understand this option or why you'd ever want to use it? Can you ...
By Kimberly L. Tripp, 05/12/2011
QUESTION: When it is a appropriate to turn on the database option FORCED parameterization? ANSWER: Before I give a specific answer, I’d like to start with a few cautionary words. ...
By Kimberly L. Tripp, 04/20/2011
Question: I recently read Kimberly’s post on USECOUNT=1 plans, and your related article Should I Optimize My SQL Server Instances for Ad Hoc Workloads in the March 2011 issue of ...
By Kimberly L. Tripp, 02/20/2011
Is it better to use OPTION (RECOMPILE) rather than dynamic SQL? Both options are likely to recompile each time, and forcing recompilation with OPTION (RECOMPILE) doesn’t have the ...
By Kimberly L. Tripp, 02/13/2011
Using local variables in statements and procedures can cause poor cardinality estimates. Alternative solutions can include rewriting the query to use literals instead of ...
By Kimberly L. Tripp, 01/24/2011
To preserve application architecture, we want to retain the GUID as a primary key when clustering on a new INT column that’s not used by the application. Of course, a nonclustered ...
By Kimberly L. Tripp, 12/13/2010
Q: When you create a new database in SQL Server 2008 and SQL Server 2005, the data and log files have the following characteristics by default:
Data: initial size 2MB; ...
By Kimberly L. Tripp, 11/26/2010
Q: I heard you recommend the new SQL Server 2008 configuration optimize for ad hoc workloads. Should I turn this option on, and why? A: Yes! In general, I recommend that this ...
By Kimberly L. Tripp, 11/07/2010
Q: I’ve heard that it’s a good idea to index my foreign key columns. Is that true?
A: The simple answer is yes. However, I’d like to discuss this in more detail because ...
By Kimberly L. Tripp, 10/18/2010
Why does SQL Server let me create the same (i.e., completely identical) index more than once?