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
http://technet.microsoft.com/en-us/magazine/cc434693.aspx It covers some of the new features in SQL 2008 w.r.t. Data Warehousing. Conor Cunningham
(Apologies to Star Trek). I received a question about trigger performance, especially the do’s and dont’s about how they are used. Let’s first start by
(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
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
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.