Category: sqlserverpedia-syndication

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 Saturday 63 Dallas: EPICITY

Post author By Jen McCown
Post date April 1, 2011
Categories In Community, SQL Saturday, SQL Saturday, SQLPASS, sqlserverpedia-syndication, SSC

SQL Saturday 63 Dallas. Will. Be. Epic. Edit: We will live cast two sessions from this event at 8:30am and 2:45pm CST Saturday, 4/2: Jen’s “Orientation: What is SQL Server, and what’s it for?” (8:30am) Rate this session. Sean’s NSFW “How to swear in an interview” (2:45pm) Rate this session. Tune in to http://bit.ly/DBAShow at […]

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