Monthly Archives: August 2015

Getting Better

When I (infrequently) post something here, it’s generally tech-related, and often specific to SQL Server. This one’s a little different. Throughout the last year and a half, I’ve improved my physical fitness dramatically, losing weight and exercising a lot. I … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

SELECT INTO

I just came across a stored procedure that does something like this: DECLARE @stmt NVARCHAR(MAX); CREATE TABLE #foo (col1 INT, col2 INT, col3 INT); SELECT @stmt = N’SELECT col1, col2, col3 INTO #foo FROM bar;’; EXEC sp_executesql @stmt; The incorrect … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

SQL Saturday #402 – Indianapolis

I’m once again presenting a session at a SQL Saturday, this time in my own backyard. SQL Saturday #402 is here in Indianapolis this Saturday. If you’re in the Indy area and spend any significant amount of time with SQL … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment