SELECT Hints, Tips, Tricks FROM Hugo Kornelis WHERE RDBMS = 'SQL Server' : SQL Server 2012

Bleeding Edge 2012 – session material

Hugo Kornelis — Sat, 27 Oct 2012 10:46:00 GMT

As promised, here are the slide deck and demo code I used for my presentation at the Bleeding Edge 2012 conference in Laško, Slovenia. Okay, I promised to have them up by Tuesday or Wednesday at worst, and it is now Saturday – my apologies for the delay....(read more)

The Curious Case of the Optimizer that doesn’t

Hugo Kornelis — Thu, 03 May 2012 22:13:00 GMT

The optimizer is the part of SQL Server that takes your query and reorders and rearranges your query to find the optimal execution plan. In theory. In practice, that doesn’t always work out well. Often, the optimizer manages to come up with brilliant...(read more)

Busy months ahead

Hugo Kornelis — Thu, 16 Feb 2012 19:48:01 GMT

Almost two months have passed since my last blog post. And while it’s true that I’ve had (much) longer breaks, I do have a good reason now. All the time that I would normally at least in part spend on preparing new blog posts is now reserved for preparing...(read more)