Category Archives: Indexes

Found: Rows from a Merge Join

About a month ago I blogged about an issue I had with a customer where a search in one area of our application returned less data than expected, and a search in a different area of the application returned the proper amount of data.  I was able to work around the issue by dropping a…

sp_helpindex: Remember what you’re missing

Back in December I blogged about the usefulness of the DISABLE INDEX option which was added in SQL Server 2005. In that post I mentioned using sp_helpindex to verify which indexes existed for a table and what columns were in those indexes. If I had to rebuild an index in SQL Server 2000, this option…

Disabling Indexes: Saving Time, Saving Space

One of the things I have to do for customers from time to time is alter data in their database. I don’t especially like doing this, simply because I’m messing with customer data and there is an immense amount of responsibility that comes with that. It’s not that I’m averse to being responsible; it can…

Seek and ye shall find

When I was thinking up names for this blog, I had a hard time not using the name my husband uses for his fantasy baseball team: The Stellato Heels.  It’s great, isn’t it?  I can boast about how fabulous it is because I didn’t think of it.  I had great visions for the logo.  Just…