Monthly Archives: February 2010

SQLServerCentral – Report Server Diagnostic Reports

Posted by on February 4, 2010 Comments Off on SQLServerCentral – Report Server Diagnostic Reports

FROM http://www.sqlservercentral.com/articles/SSRS/69257/

Michael Davis has published this article and RDL files
on SQLServerCentral.com.  Just happened to read the email, today.

SSRS is a powerful tool, but the ReportServer tool lacks some administrative reporting.  Micahel Dais has done a great job filling in that gap!

Super Easy to deploy and gives the end user a better glimpse
into what’s happening on their SSRS installation. While it is
written for a SQL 2005 , some posters announced they had no
problems working against SQL 2008 installations.

Thanks Michael!

Read more »

T-SQL Using Parameter Table like a Cursor

Posted by on February 3, 2010 Comments Off on T-SQL Using Parameter Table like a Cursor

The Google gods seem to like a very old page of mine about using Cursors in T-SQL. So, from time to time I get commnets via email.  Thought I  would share an alternative to using cursors.

Read more »