One of my favorite subjects of late. Just watch out if your variable expression makes calls to a custom assembly. It doesn’t always seem to work! SQL Server Reporting Services Report and Group Variable References.
The trick is to stop and start the RS service at the time of day when it should start up. The recycle time is relative to that, not the time that it last recycled… Prevent SQL Server Reporting Services Slow Startup.
In the “better late than never” category… (I missed this because I had given up looking for it. Besides, I am presently trapped in RS 2008 RTM hell.) SQL Server Data Tools – Business Intelligence for Visual Studio 2013 SSDT BI – Analysis Services and PowerPivot Team Blog – Site Home … Continue reading →
Logging in Maintenance Plans – SQLServerCentral.
Why Local Variables are Bad for Tuning Stored ProceduresBrent Ozar Unlimited®.
Cursor-Killing: Retrieving Recently Modified Data – SQLServerCentral.
TSQL User-Defined Functions: Ten Questions You Were Too Shy To Ask.
Is that ever an understatement. Nevertheless, I have been finding good uses for report and group variables, in those situations where they can be used, which is in RS expressions in specific places. Of course as with any item, a few restrictions do exist in the use of variables. Link: SQL … Continue reading →
…for the sake of the argument, can we agree that stress and insanity are bad things? Awesome. Welcome to programming. via Programming Sucks.
The Performance of Traversing a SQL Hierarchy.