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