Category: Tips

SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)

Post author By Jen McCown
Post date July 14, 2011
Categories In Random helpfulness, sqlserverpedia-syndication, SSC, Tips, TSQL
1 Comment on SELECT INTO and IDENTITY (or, BOL is Sorta Wrong)

I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server Books Online. This time, I was arrested by this little nugget: When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one of the following conditions […]

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