Author Archives: Jay

@@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

#OutrunCancer

A lot can happen in a couple of hours. Right now, I am taking part in the OneAmerica 500 Festival Mini-Marathon. My start time is 8:15, and if I stay on pace I should cross the finish line around 10:30. … 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

Subscriber Lists v Data Extensions

For those of you in the Indianapolis area who work with the Salesforce Marketing Cloud, you may be interested in Tuesday night’s Marketing Cloud Developers Group meeting. I will be presenting a session entitled “Subscriber Lists versus Data Extensions: Choosing … 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

And So We Meet Again

This is not a technical topic, but one I find myself very passionate about. An article today at NPR brought it to the forefront. As my organization matures, like every organization, rampant movement is slowly replaced by more controlled but … 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