Category: Tech and Learning

T-SQL Formatting Workaround (Word Macro)

Post author By Jen McCown
Post date June 20, 2011
Categories In Random helpfulness, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
1 Comment on T-SQL Formatting Workaround (Word Macro)

Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too terribly much. Enjoy! I love a well-formatted SELECT statement. To that end, I often use Redgate’s SQL Prompt (with handy-dandy auto-formatting feature, just CTRL-K-Y!) to keep my code in line. But sometimes a job won’t […]

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

Overview: SQL Server (SQL Saturday #63)

Post author By Jen McCown
Post date April 2, 2011
Categories In Beginner, NTSSUG, SQL Saturday, sql server, SQLPASS, TSQL

Here are all the things related to the most awesome Overview: SQL Server session I gave at SQL Saturday #63 April 2, 2011. This session was live streamed on http://www.bit.ly/DBAShow. That recording (without screen shots) is here. As always, feel free to write with questions and comments! Links: SQL Server Developer Edition, free to students. DreamSpark.com SQL Server […]