Category: Tech and Learning

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. […]

Little Workaround in Report Manager

Post author By Jen McCown
Post date September 9, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, SSRS, Tips
2 Comments on Little Workaround in Report Manager

I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report), and from there clicking a link to generate and export a subreport (say, Individual Widget Report). The problem with this is that it wipes out initial report and its parameters…so every single time, I had […]

Applied SQL: Server Side Traces

Post author By Jen McCown
Post date August 29, 2011
Categories In Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
3 Comments on Applied SQL: Server Side Traces

It’s time to get your server side trace on, with a little practical application! I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL, basic experience with SQL Profiler Reading: SQLServerPedia article: The Server-side Trace: What, Why, and How SQL Server Books Online […]