Welcome to SqlAdvice Sign in | Join | Help

January 2007 - Posts

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...
Quick heads-up on a recently published article I did for SQLTeam.com . The article examines SQL Server Integration Services' Fuzzy-Lookup transformation for use in data-cleansing routines. If you're interested, head over to the article - there's even Read More...
0 Comments
Filed under: ,