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…


Dependency magic: Now you don’t see it, Now you do

If a user-defined function (UDF) is created prior to creating a stored procedure, object dependencies are properly listed through sp_depends. However, if you create the stored procedure first, then later create the UDF (which is allowed due to delayed name resolution), object dependencies are not displayed. In such cases you may see the following error:…


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