Category: Intermediate

Varying Results with Subquery, ORDER BY, MAXDOP

Post author By Jen McCown
Post date April 4, 2011
Categories In Intermediate, NTSSUG, Random helpfulness, SQL Saturday, SQL Saturday, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips
1 Comment on 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 Welker (blog) asked about a problem with a query that’s getting varying results depending on the MAXDOP […]

SQL Math: Whole Numbers, Real Numbers

Post author By Jen McCown
Post date March 28, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
3 Comments on 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 common SQL Math Misunderstanding came up again recently with a fellow SQL practitioner, so off […]

Maaaaaagic Tables!!!

Post author By Jen McCown
Post date March 24, 2011
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, TSQL
19 Comments on Maaaaaagic Tables!!!

I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X in the initial tech screen was, and I quote: “What are magic tables?” ……I’m sorry, what? No, really. “What are magic tables?” Uhm. There’s no such thing. Oh, yes there are! This is my favorite question. […]