SQL and the like

Browse by Tags

All Tags » SQLServerPedia Syndication (RSS)
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"...
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...
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...
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...
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...
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...