Category Archives: Level

SSRS Tip: Hide a tablix if no rows returned

Posted on January 19, 2012 by Jen McCown

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 … Continue reading →

Posted in sqlserverpedia-syndication, SSC, SSRS, Tips | 2 Comments

SQL Server is Smarter Than You

Posted on December 8, 2011 by Jen McCown

I had a brief email discussion recently, which could be effectively be boiled down to: Them: “Are foreign key constraints more performant than referential integrity triggers?” Me: “Yes.” *stomp*stomp*stomp*stomp* “Yes, they are.” Let’s start with a generic statement, and get … Continue reading →

Posted in Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC | 2 Comments

Another reason that T-SQL beats the GUI

Posted on November 14, 2011 by Jen McCown

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 … Continue reading →

Posted in sql server, sqlserverpedia-syndication, SSC, Tips, TSQL | 4 Comments