SQL 2008 Geometry type tidbits
I spent some time playing with the SQL 2008 geometry data type. This post will cover some of the things I have learned about how
I spent some time playing with the SQL 2008 geometry data type. This post will cover some of the things I have learned about how
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
I started off tonight playing with the new page compression feature. So far I like it. I haven’t found something yet about which I want
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
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.