REPEATABLE READ

Browse by Tags

Full Text Indexing Overhead

Posted Friday, November 09, 2007 3:26 PM by michael.k.campbell

I think that there's a tendency among DBAs and SQL Server wonks to be a bit dismissive of Full Text Indexing. I think that in a lot of cases people tend to think of it in terms of adding significant overhead. For a long time I actually looked at it as Read More...

0 Comments

Filed under: Tips And Tricks, Raves

Burned again by HyperThreading on SQL Server 2000

Posted Tuesday, February 13, 2007 11:51 AM by michael.k.campbell

One of my clients recently had a problem where a query with a semi-measly execution cost of .3 was taking 25 seconds to return. Worse, forcing the query to use a suitable index (instead of the PK with accompanying bookmarks) had a cost of 4.8 and returned Read More...

3 Comments

Filed under: Tips And Tricks, Not what it seems

Micro Indexing

Posted Thursday, January 25, 2007 12:12 PM by michael.k.campbell

It's almost a rule of thumb to avoid indexing strategies on tables with less than a few thousand rows. The reason, of course, is that SQL Server will frequently just ignore indexes on 'tiny' tables - preferring instead to perform table scans. However, Read More...

0 Comments

Filed under: Theory vs Reality, Tips And Tricks

Using Virtualization to fight ... Virtualization

Posted Thursday, April 20, 2006 4:54 PM by michael.k.campbell

VPN Software should come with big warning labels: "WARNING: Does not play well with others." As a consultant I frequently need to gain access to remote networks via VPN. This means I'm frequently hosing myself by installing yet another VPN client. That, Read More...

1 Comments

Filed under: Tips And Tricks, How To's, Raves

SQL Server Unit Testing: Sprocs

Posted Thursday, April 06, 2006 9:41 AM by michael.k.campbell

As a consultant, it's not uncommon for me to need to rewrite a poorly performing query or sproc without a full understanding of the underlying biz rules or context. Improved performance is the stated goal, but data fidelity is implied as critical. Enter Read More...

1 Comments

Filed under: Tips And Tricks, How To's, Raves

Nibbling Deletes - Intro

Posted Tuesday, September 20, 2005 11:10 PM by RepeatableRead

So, your application was a success. You're getting oodles and oodles of traffic. Only, it's building up faster than you had anticipated, and after a bit of calculation, you've determined that if the present trends persist, you'll have 24 TB of data within Read More...

10 Comments

Filed under: Tips And Tricks, How To's

Max Degree of Parallelism

Posted Tuesday, May 24, 2005 5:59 PM by RepeatableRead

In a previous life (actually two previous lives), I was a production DBA. One of the environments that I inherited had some ... issues. There were a number of Clustered SQL Server installations -- oodles of hardware, all churning to keep product inventory, Read More...

1 Comments

Filed under: Tips And Tricks, How To's