Tag Archives: sql

SELECT TOP 1 * FROM PASS.Summit2015;

I’ve been uncharacteristically quiet during this particular Summit. I picked up a cold on the way out there, which made the week a bit different than I was expecting. Still, I always take away quite a lot each time 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

@@ROWCOUNT Strikes Again

Just when I thought I’d been thwarted the last time by @@ROWCOUNT, along comes this gem: begin try select top 10 * from sys.objects; end try begin catch select top 20 * from sys.objects; end catch; select @@rowcount; Yup, it … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

SQL Saturday #421 – Columbus

They say the only three numbers in computer science are 0, 1, and N. Well, I’ll be at the SQL Saturday in Columbus, Ohio, on July 11th, giving a session entitled Playing in Traffic. It’s really a talk about keeping … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

I <3 SET STATISTICS IO ON

Once upon a time, a senior DBA at the Salesforce Marketing Cloud had pointed out a very small performance tweak to me. I was curious about whether or not it still held true in SQL Server 2014, so I wrote … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Here We Go Again

I’ll be presenting my session from SQL Saturday #358 at this month’s IndyPASS meeting next Tuesday, 3/17. I’m looking forward to all the heckling I’ll be getting from the Salesforce Marketing Cloud‘s performance DBA’s that will be in attendance. Meeting … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

[n]varchar truncation

I was very happy with the response to my SQL Saturday session in Albuquerque. To those who attended and provided me with feedback, thank you. One of the items I covered led to this tweet from @coffegrl: Which just made … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

A-ha Moments

I’m preparing for my session at SQL Saturday #358 in Albuquerque next week, and something finally clicked. I’ll be adding another demo to my section on the differences between EXEC and sp_executesql now. Want to find out what it is? … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Albuquerque SQL Saturday

I’m excited to announce that I’ll be presenting “Fast and Furious Dynamic SQL” at SQL Saturday #358 in Albuquerque on February 7th, 2015. This will be my first time as a PASS presenter, so please save your best heckling and … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment