Category Archives: Query Tuning

Parallel Performance in London: SQLbits XIV, Superheros Edition!

I’m happy to announce that I’ll be returning again this year to the UK’s premier SQL Server conference, SQLbits. This year’s show is in London, and has a Superheros theme; it should be a great time. On Wednesday March 4th, I’ll be delivering “Better Performance Through Parallelism” as a full-day preconference seminar. This seminar teaches you how to properly leverage SQL Server’s parallel processing capabilities to greatly improve performance of your biggest queries. It includes a large amount of…(read more)

PASS Summit 2014: Manhandling Parallelism – Demos

Just a quick post to say thank you to everyone who attended today’s Manhandling Parallelism talk! I hope you had even half as much fun as I did. For those of you who didn’t attend, the talk was recorded and broadcast on “PASS TV,” and I’m sure it will be available somewhere soon for on-demand viewing. The demos are attached. Let me know in the comments area if you have any questions!…(read more)

SQL Saturday Chicago (#291) – Clash of the Row Goals – Demos

Thank you to everyone who joined me today at SQL Saturday Chicago for my “Clash of the Row Goals” session. I’m honored that so many people would attend a talk with such an incredibly arcane title — and always glad to find a curious, interested, and intelligent audience. The demos I showed during the session are attached to this post. If you have any followup questions, feel free to leave a comment below. Enjoy!…(read more)

SQL Saturday Chicago…and the Gentle Art of Planscaping!

Three weeks from now I’ll be visiting Chicago to participate in SQL Saturday. I’ll offer two different learning opportunities: On Friday, April 25, you can join me for a full day seminar on parallelism and performance in SQL Server . This class covers in-depth background on the hows and whys behind SQL Server’s parallel processing, followed by an investigation of advanced techniques that you can use to improve performance of some queries by an order of magnitude or more. The class is filling up,…(read more)

Demos: SQL Saturday Boston (#262) – Clash of the Row Goals!

Thanks to everyone who joined me yesterday afternoon in Cambridge for my Clash of the Row Goals talk. It was great to receive such a welcome reception for a rather out there topic. Three things I should clarify for those who attended: The Many() function appeared to create an invalid estimate in one case; but that was due to auto-parameterization (which one of the attendees in the front row correctly called out at the time; but I’m not sure everyone heard her) Regarding the demo that failed at the…(read more)

SQLRally Nordic and SQLRally Amsterdam: Wrap Up and Demos

First and foremost : Huge thanks, and huge apologies, to everyone who attended my sessions at these events. I promised to post materials last week, and there is no good excuse for tardiness. My dog did not eat my computer. I don’t have a dog. And if I did, she would far prefer a nice rib eye to a hard chunk of plastic. Now, on to the purpose of this post… Last week I was lucky enough to have a first visit to each of two amazing cities, Stockholm and Amsterdam. Both cities, as mentioned previously…(read more)