Mr. Proactive and Miss T. Proactive

Where Premier Field Engineering shares with the community

Browse by Tags

Related Posts
  • Blog Post: 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 is serious. We...
  • Blog Post: 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...
  • Blog Post: 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...