New blog location
Here is the new blog – please update those readers. http://blogs.msdn.com/conor_cunningham_msft/default.aspx I’m getting settled into working for Microsoft again – it’s basically like drinking from
Here is the new blog – please update those readers. http://blogs.msdn.com/conor_cunningham_msft/default.aspx I’m getting settled into working for Microsoft again – it’s basically like drinking from
As I mentioned in my previous post, I’m going to be taking on a new job soon. I’m actually going back to work for Microsoft,
Well, I can tell you that I’ve been doing a few things lately. 1. I’m writing a chapter for an upcoming book – lots of
(I am still around – I’ve just been busy with a few personal projects of late – keep asking questions if you have them). I
I had a question from a reader about contradiction detection. The basic idea is to determine that this kind of query: SELECT * FROM TABLE
A follow-up from my previous post. Is COUNT(1) faster than COUNT(*)? No, COUNT(1) is mapped into COUNT(*) early in the QP. From the logic of
So COUNT isn't an operator, but you should view this post as a "what is this operator" kind of post since I talk about how
One of the areas I managed in SQL Server had to do with the code that automatically builds statistics and uses them during query optimization
I’ve returned from a small trip and I will be preparing my next SQL post soon. I’ve been struggling with slow POP3 sync behavior on
Based on my previous post describing the differences between ANSI-89 and ANSI-92+ join syntaxes and recommendations, I had a follow-up question in a comment which
I had a request from a reader that I’ll answer today about when to do joins in the ON clause and when to do them
I don’t know about you, but groupby is one of my favorite operators. There are a TON of interesting optimizations that a QP considers when
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.