in

SQL Server Community Blogs

Voices of the SQL Server Community

Browse by Tags

  • The problem with local variables

    Have you ever been writing a query and just cannot get it to use the right index? This could be one of the reasons why. Let's use this query with local variables as our example. declare @Start datetime declare @End datetime select @Start = '2004-08-01 00:00:00.000' select @End = '2004-07-28 00:00:00...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on 01-25-2008
  • SQL Server 2008 Plan Guides from Cache

    Uhoh... I can see some junior developers going crazy with this. One of the things that kept plan guides from being over used was the fact that they are kind of hard :) Well, Microsoft built their empire making hard stuff easy. They do it again with sp_create_plan_guide_from_cache. Let's look at this...
    Posted to Jason Massie's SQL blog (Weblog) by JasonMassie on 01-18-2008
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems