Category Archives: TSQL

Great Tools for Formatting T-SQL

Posted on September 12, 2011 by Jen McCown

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

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Random helpfulness, sqlserverpedia-syndication, SSC, Tips, TSQL | Tagged | 7 Comments

Applied SQL: Server Side Traces

Posted on August 29, 2011 by Jen McCown

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

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL | Tagged | 3 Comments

Applied SQL: sys.sql_modules

Posted on August 18, 2011 by Jen McCown

I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page. Prerequisites: basic T-SQL (including JOINs and LIKE), basic knowledge of catalog views Reading: SQL Server Books Online sys.sql_modules article. Level 1 … Continue reading →

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Applied SQL, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL | Tagged | 15 Comments