Category Archives: Intermediate

Applied SQL: sys.sql_modules

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

Varying Results with Subquery, ORDER BY, MAXDOP

In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking up (as long as you attribute properly).  Speaking of which… Saturday in the SQL Saturday #63 Dallas speaker room, Erin … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Intermediate, NTSSUG, Random helpfulness, SQL Saturday, SQL Saturday, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips | 1 Comment

SQL Math: Whole Numbers, Real Numbers

It’s been a long time since grade school math, and for some the details have become kinda fuzzy. I’m no [insert name of famous math genius here], but I’ve been able to explain some basic things over the years.  A … Continue reading

Share on TwitterShare on LinkedInShare on TumblrSubmit to StumbleUponSave on DeliciousDigg ThisSubmit to reddit
Posted in Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL | 1 Comment