SQL Server Blogs

Voices from the UK SQL Server Community

Search

Page 1 of 1 (9 items)
  • 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
  • Phil Factor Speed Phreak SQL Challenge Number 3

    The latest Phil Factor challenge is now active here. The prize has now been increased to $100
    Posted to SQL and the like (Weblog) by Anonymous on Fri, Dec 4 2009
  • Direct EMailing of SSRS Reports via SQLCLR

    This is something that I was quite surprised that wasn't supported out of the tin with SSRS. When you schedule an email delivery, the report is always sent as an attachment. What would be great, if when you specified the render format as "MHTML", you had the option that the report forms the body of the email. Taking that one ...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
  • SQL and contiguous data ranges.

    As the saying goes "work smarter, not harder", this is definitely the case for SQL. If you have a poorly performing query, then you are not only affecting that one user but diverting precious machine resources needlessly. This is doubly true if its part of the 20% of code executed 80% of the time. Here's one smart solution to a ...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
  • Optimal Query Plans With Unbalanced Data Loads

    Sql Server is great at producing and caching efficient query plans.  However these plans may not be the most efficient based upon the parameters passed into subsequent calls off a stored procedure. In this article I am assuming that you have read both of Erland Sommarskogs articles The Curse and Blessings of Dynamic SQL and Dynamic Search ...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
  • Catch all queries and indexing

    Amongst many others, Gail Shaw has blogged on the subject of catch all queries.  On many occasions I have needed to do something similar and found performance to be pretty dire on large tables.  Typically I would use dynamic SQL to generate the query but there are occasions where that is not possible. After a wee bit of poking around and ...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
  • Fixed Headers With SSRS

    Within SSRS, or at least Report Builder 2, there are a few options that would imply that headers can be fixed. Heres how to really fix them,  leave all the above settings unchecked and save the rdl to a local file.  Load it up in notepad ( or an XML editor if you are that way inclined). Then add in this line Save the file , ...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
  • Another TSQL random length random string generator

    The following function function will return you a random string of the specified characters, for a length of between @StrLenLo and @StrLenHi.  The only Oddity with using this function is that if the parameters are not dependant upon data within a table SQLServer will create a hash join which will cause the same value to be returned.  ...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
  • A bit of self back slapping

    Recently Adam Machanic issued a fresh SQL challenge based upon concatenating string data.  The results are now in.   Although I was eliminated in the first round, appeal lodged :) ,  just looking at the execution times mine were pretty damn quick.  I feel particularly good as entries by Itzik Ben-Gan  were slower than ...
    Posted to SQL and the like (Weblog) by Anonymous on Mon, Jun 1 2009
Page 1 of 1 (9 items)
Powered by Community Server (Commercial Edition), by Telligent Systems