Category: Level

SSRS Tip: Hide a tablix if no rows returned

Post author By Jen McCown
Post date January 19, 2012
Categories In sqlserverpedia-syndication, SSC, SSRS, Tips
7 Comments on SSRS Tip: Hide a tablix if no rows returned

I have a tablix in an SSRS report, populated by a query that might or might not return any rows. What I want to do is make that tablix invisible if there are no rows returned. First off, to set conditional visibility. Right-click the tablix and select Properties. Click Visibility. Select Show or hide based […]

Another reason that T-SQL beats the GUI

Post author By Jen McCown
Post date November 14, 2011
Categories In sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
4 Comments on Another reason that T-SQL beats the GUI

In IT, we have a few very solid and universal principles that no one ever argues with. The first of these is Cover Your Ass (CYA). CYA is so universal and popular because things go wrong, blame gets thrown, and DBAs find themselves under a metaphorical bus. Nobody likes the underside of that bus. It’s […]

Great Tools for Formatting T-SQL

Post author By Jen McCown
Post date September 12, 2011
Categories In Random helpfulness, sqlserverpedia-syndication, SSC, Tips, TSQL
10 Comments on Great Tools for Formatting T-SQL

I have a big rant I add to….well, to every single SQL session I give. That rant is on formatting code. You see, (I say,) you can’t even begin to understand or optimize a query if it’s not formatted…and by “formattted”, I mean breaking out query clauses onto different lines, indenting column lists, etc etc. […]