Conor vs. SQL

Conor Cunningham's blog on SQL Server, data-driven applications, and pretty much whatever other random stuff he decides to post.

Conor vs. SQLBits

A quick announcement to let you know that I will be speaking at the SQLBits conference in London on...

Author: Conor Cunningham [MSFT] Date: 03/14/2010

Loading Data into SQL

(I didn’t write this, so no Conor vs. today, folks :)  ...

Author: Conor Cunningham [MSFT] Date: 02/05/2010

Conor vs. Data Warehouses (an introduction)

I received this question from an internal (as in within Microsoft but not in the SQL Server team)...

Author: Conor Cunningham [MSFT] Date: 01/29/2010

Conor vs. His Schedule

I apologize for those of you who have outstanding questions in my inbox.  I have been quite...

Author: Conor Cunningham [MSFT] Date: 01/29/2010

Conor vs. FOREIGN KEY join elimination

I received a question from a friend in Brazil related to foreign keys and join elimination in SQL...

Author: Conor Cunningham [MSFT] Date: 11/12/2009

Conor vs. Windows 7

(Not a SQL Server post) I have been meaning to install Windows 7, and I got around to doing it last...

Author: Conor Cunningham [MSFT] Date: 10/27/2009

Conor vs. UNIQUE in Index Definitions

I gave a talk to the Austin-area PASS group last night on B-Tree indexing in SQL Server, and I...

Author: Conor Cunningham [MSFT] Date: 10/21/2009

Conor vs. Statement Offsets

As most of you have figured out by now, I work mostly on queries :).  One of the things that I...

Author: Conor Cunningham [MSFT] Date: 08/13/2009

Server Cursors

My coworker Marc posted up a good introduction into the different server cursor models and you can...

Author: Conor Cunningham [MSFT] Date: 08/13/2009

Conor vs. Stats NORECOMPUTE

It’s been a busy summer.  I got back from vacation and have been hard at work on new features...

Author: Conor Cunningham [MSFT] Date: 08/13/2009

Conor vs. Dynamic SQL vs. Procedures vs. Plan Quality for Parameterized Queries

I received a question from a customer today about query plan choice for a parameterized query -...

Author: Conor Cunningham [MSFT] Date: 06/03/2009

Conor vs. Recompiles, part 2

Thanks to those of you who replied to my previous post.  I spent the last week or so talking...

Author: Conor Cunningham [MSFT] Date: 05/25/2009

Conor vs. Recompiles

I have a question for you guys about how do you force a recompile for a single query today?  ...

Author: Conor Cunningham [MSFT] Date: 05/18/2009

Do Filtered Statistics update as frequently as normal statistics?

I received a question this week about whether filtered statistics update as frequently as regular...

Author: Conor Cunningham [MSFT] Date: 04/18/2009

SQL Server 2008 Internals Book Now Available!

For those of you waiting for the new "Inside SQL Server" book, it is actually out...

Author: Conor Cunningham [MSFT] Date: 03/23/2009

Conor vs. Isolation Level Upgrade on UPDATE/DELETE Cascading RI

A customer recently asked our support organization about an unexplained series of range locks that...

Author: Conor Cunningham [MSFT] Date: 03/13/2009

Conor vs. Indexed View Updates

(as ANSI NULLs is one of the requirements for indexed views, I thought I’d give you some perspective...

Author: Conor Cunningham [MSFT] Date: 02/12/2009

Conor vs. Non-ANSI NULLs, part 1

I was thinking about indexed views. Well, more specifically, I was thinking about why indexed views...

Author: Conor Cunningham [MSFT] Date: 02/08/2009

Conor vs. MERGE and PRIMARY KEY collisions

MERGE is a new operation added in SQL Server 2008. It has all sorts of knobs, bells, and whistles....

Author: Conor Cunningham [MSFT] Date: 02/04/2009

Conor vs. His Printer

As many of you may know, I work from my house most of the time - I have a nice office that is quiet...

Author: Conor Cunningham [MSFT] Date: 01/16/2009

OPTIMIZE FOR UNKNOWN - How could that possibly make any sense???

Yes, I'm alive. I have been chatting with my wife about the times I need to "go dark" - in this...

Author: Conor Cunningham [MSFT] Date: 01/16/2009

What I learned at PASS - ETL in Queries.

I attended only a small number of the talks at PASS. I really enjoyed Bob Ward's talk on memory and...

Author: Conor Cunningham [MSFT] Date: 11/25/2008

PASS in Seattle! W00t!

I hope to see folks at PASS - please look for me at the Ask the Experts booth for Query...

Author: Conor Cunningham [MSFT] Date: 11/14/2008

Conor vs. Win2008 Hypervisor

I've been building a new machine and I have put Win2K8 Enterprise on it. While I have no specific...

Author: Conor Cunningham [MSFT] Date: 11/04/2008

More Business Logic Validation

I've gotten a few data points, but I don't think I've had enough yet to complete my sample. I'm...

Author: Conor Cunningham [MSFT] Date: 10/31/2008

CHECK Constraints vs. TRIGGERS

I've been having a conversation with a customer about CHECK constraints and TRIGGERs, and I thought...

Author: Conor Cunningham [MSFT] Date: 10/28/2008

PASS Community Summit 2008 - Seattle

I just got all of my travel arrangements set up for PASS in Seattle. I'm excited to get a chance to...

Author: Conor Cunningham [MSFT] Date: 10/24/2008

CONVERT vs. CONVERT_IMPLICIT

Today's question comes from a friend I have in Brazil. Please, tell-me one thing, is there any...

Author: Conor Cunningham [MSFT] Date: 10/24/2008

Where's Conor?

One of the interesting parts of working on products is that you have to build the features before...

Author: Conor Cunningham [MSFT] Date: 09/29/2008

Whew! I'm done with the Optimizer Chapter for the next Inside SQL Server book!

I think I'm pretty much done with the chapter for the next Inside SQL Server book on the SQL Server...

Author: Conor Cunningham [MSFT] Date: 08/31/2008

No Seatbelt - Expecting Order without ORDER BY

One of the greatest lessons I've learned in building software is that every technical implementation...

Author: Conor Cunningham [MSFT] Date: 08/27/2008

Where's my Jetpack???

I'd like to talk about storage.. well, backup. Not SQL Server backup, just "I wish to keep a copy of...

Author: Conor Cunningham [MSFT] Date: 08/24/2008

Foreign Keys are our friends...

I often find customers who question the value of database-enforced integrity constraints. While...

Author: Conor Cunningham [MSFT] Date: 08/07/2008

Let's talk Upgrades! SQL 2000->SQL 2005, SQL 2005->SQL 2008, and service pack deployments

As Microsoft is about to release a new version of SQL Server, I would like to spend some time on...

Author: Conor Cunningham [MSFT] Date: 07/28/2008

Statistics Sample Rates

I had a question about sample rates for statistics yesterday for SQL Server 200x statistics. Here is...

Author: Conor Cunningham [MSFT] Date: 07/24/2008

Darn Gigabit switches...

I had a netgear gs108 (8 port gigabit switch) die on me this evening. Perhaps it is me working from...

Author: Conor Cunningham [MSFT] Date: 07/23/2008

The Eagle has Landed...

Hi - This will be Conor's new blog home. <best cheesy television voice> You may remember me...

Author: Conor Cunningham [MSFT] Date: 07/23/2008

<Previous