Extra Logical Reads Are Not So Logical

When normalizing a database, foreign keys are commonly created in order to maintain data integrity between the parent and child tables. Oftentimes, however, the foreign key columns are overlooked when it comes to proper indexing strategy. Using the Adventureworks2008R2 sample database, available at http://msftdbprodsamples.codeplex.com/, let’s look at what happens when a join is performed on…


Hello World!

Hi There! My name is Mr. (Scoop) Proactive, and I am one of the Community Leads for Premier Field Engineering (PFE). My partner in crime is Miss T. Proactive (no relation). Miss T. won’t ever tell me her real first name. She says it is “Tips and Tricks”, but I can never tell if she…

0