in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » tsql (RSS)

Browse by Tags

  • Sub query pass through

    Occasionally in forums and on client sites I see conditional subqueries in statements. This is where the developer has decided that it is only necessary to process some data under a certain condition.  By way of example, something like this : Create Procedure GetOrder @SalesOrderId integer, @CountDetails...
    Posted to SQL and the like (Weblog) by Anonymous on Fri, Mar 22 2013
  • Finding the maximum value/date across columns

    While working on some code recently I discovered a neat little trick to find the maximum value across several columns….. So the starting point was finding the maximum date across several related tables and storing the maximum value against an aggregated record. Here's the sample setup code: USE TEMPDB...
    Posted to Atul Thakor (Weblog) by AtulThakor on Mon, Nov 21 2011
  • Performance Tuning and Query Optimisation–SQLBits Training Day

    I will be doing a training day at SQLbits in April on Performance Tuning and Query Optimisation. This is the outline for the day. Its going to be an intense day, I look forward to seeing you there. To register go to http://www. sqlbits .com/information/registration.aspx . Places are limited so make sure...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sat, Jan 29 2011
  • Denali Paging–Key seek lookups

    In my previous post “ Denali Paging – is it win.win ? ” I demonstrated the use of using the Paging functionality within Denali.  On reflection,  I think i may of been a little unfair and should of continued always planned to continue my investigations to the next step. In Pauls article , he...
    Posted to SQL and the like (Weblog) by Dave Ballantyne on Fri, Nov 19 2010
  • Denali Paging–Is it win/win ?

    UPDATE : 2012-07-26 : My latest commentry of the paging subject can be found here : http://sqlblogcasts.com/blogs/sqlandthelike/archive/2012/04/26/offset-without-offset.aspx I'm not one for automatically poo-pooing new ideas, new practices and new technology. Rather I like to take a measured view...
    Posted to SQL and the like (Weblog) by Dave Ballantyne on Wed, Nov 10 2010
  • SQL Server Denali – Whats new for TSQL?

    This is a placeholder for content about what’s new in SQL Server vNext aka Denali. I will be updating this as more content is published.
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Nov 7 2010
  • The best things in life are free

    Greg Gonzalez ( blog | twitter ) of SqlSentry , last night released a very cool new and free product.  Plan explorer is a tool for examining query plans and overcomes many of the limitations of viewing plans within Management studio.  If you view plans a lot i would recommend that you give...
    Posted to SQL and the like (Weblog) by Dave Ballantyne on Thu, Oct 21 2010
  • An impossible case

    In a previous blog entry ( Inconsistent NullIf behaviour ), Jeff Moden and Dan Halliday ( twitter ) both made a very similar observation. When executing this code Code Snippet select top ( 10 ) abs ( checksum ( newid ()))% 4 from sys . objects the only possible values returned can be 0,1,2 or 3. Anything...
    Posted to SQL and the like (Weblog) by Dave Ballantyne on Mon, Sep 6 2010
  • Inconsistent NullIF Behaviour ?

    NullIf can be a very handy function sometimes. For those who have not used it, if the result of the two parameters are equal then null is returned. So if we execute : Code Snippet Select nullif ( 10 , 10 ) as Result1 Select nullif ( 10 , 9 ) as Result2 We get the result of For some test data, I required...
    Posted to SQL and the like (Weblog) by Dave Ballantyne on Fri, Aug 6 2010
  • What line does the error line number refer to?

    You’ve got an error and it gives you a line number Msg 50000, Level 16, State 1, Procedure TestToSeeWhatTheErrorLineNumberRefersTo, Line 14 Some Error What line does that actually refer to? Well its the line in the original batch that compiled the procedure and so in the case below it includes the comments...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jul 15 2010
Page 1 of 6 (60 items) 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems