in

SQL Server Blogs

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

Browse by Tags

  • 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...
    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 Sommarskog’s articles The Curse and...
    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...
    Posted to SQL and the like (Weblog) by Anonymous on Thu, Aug 27 2009
Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems