Category: SQL Server 2008

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

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 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

You may recall my previous posts on my trouble with SQL 2008 CTP6.  I’ve made some progress on fixing my machine that I thought I’d

So as you proceed up the river into the jungle, searching for answers about how the query optimizer works, I’ll ask you one question: Did

So I’ll be posting explanations for each query operator in the output query trees that you can see through “set showplan_text on” in SQL Server. 

I’ve been trying to think of a good way to introduce how SQL Server does subqueries based on a question from a reader.  One of

This post builds upon my previous post on some of the various kinds of plans for the IN operator.  I will cover some of the

I’ve already received a few comments and mails from people asking questions… One comment I’ve received is about LINQ’s IN operator(method?) and SQL Server plan

Here is the introductory post to my new blog on SQL, data-driven applications, performance, scaling, and anything else I feel like posting.  For those of