Blog - Title

  • Conor vs. SQL

    Conor vs. Icelandic Volcano/SQLBits 6

    • 1 Comments
    Greetings all.  I just had a fascinating week.  I was invited to go give a talk at the SQLBits conference in London, England and I flew over on Wednesday/Thursday for a talk on Friday.  I was supposed to leave on Saturday but found myself...
  • Conor vs. SQL

    Conor vs. SQLBits

    • 3 Comments
    A quick announcement to let you know that I will be speaking at the SQLBits conference in London on April 16th.  My talk will be a 400-level talk on how the Query Optimizer works.  I am excited to get to go to London to talk to people about...
  • Conor vs. SQL

    Loading Data into SQL

    • 1 Comments
    (I didn’t write this, so no Conor vs. today, folks :)   http://msdn.microsoft.com/en-us/library/dd425070.aspx This is a good read on the various ways to load lots of data into SQL Server.  Enjoy!   Conor
  • Conor vs. SQL

    Conor vs. Data Warehouses (an introduction)

    • 1 Comments
    I received this question from an internal (as in within Microsoft but not in the SQL Server team) user of SQL Server.  The basic question has to do with how you set up a data warehouse and whether one should or should not create foreign keys in a...
  • Conor vs. SQL

    Conor vs. His Schedule

    • 0 Comments
    I apologize for those of you who have outstanding questions in my inbox.  I have been quite busy at work these days working on what I think are awesome features for a future release of SQL Server.  I resolve to be better in answering your mails...
  • Conor vs. SQL

    Conor vs. “Does Join Order Matter?”

    • 4 Comments
    I got this question/claim again this week, so I’ll write a blog post on it while I wait for my build to complete: It usually goes something like “When I rewrite my query, SQL Server gives me a different plan.  Therefore, I should rewrite all my queries...
  • Conor vs. SQL

    Conor vs. FOREIGN KEY join elimination

    • 2 Comments
    I received a question from a friend in Brazil related to foreign keys and join elimination in SQL Server.  Yes, SQL Server can detect that some joins are not needed to return results to the user and skip them.  What is this evil magic, you ask...
  • Conor vs. SQL

    Conor vs. Windows 7

    • 0 Comments
    (Not a SQL Server post) I have been meaning to install Windows 7, and I got around to doing it last night.  I usually run Windows 2003/8 Server for work, so my interest in the consumer side is perhaps not as high as some others.  Nevertheless...
  • Conor vs. SQL

    Conor vs. UNIQUE in Index Definitions

    • 1 Comments
    I gave a talk to the Austin-area PASS group last night on B-Tree indexing in SQL Server, and I received a question about whether to make clustered indexes UNIQUE or not (assuming the data is unique on the key columns).  The expectation was that this...
  • Conor vs. SQL

    Conor vs. Statement Offsets

    • 0 Comments
    As most of you have figured out by now, I work mostly on queries :).  One of the things that I often need to do is to get a statement out of a batch so that I can go look more closely at a query plan (and, in my case, the code that generates it)...
  • Conor vs. SQL

    Server Cursors

    • 0 Comments
    My coworker Marc posted up a good introduction into the different server cursor models and you can see it here: http://blogs.msdn.com/sqlqueryprocessing/archive/2009/08/12/understanding-sql-server-fast-forward-server-cursors.aspx
  • Conor vs. SQL

    Conor vs. Stats NORECOMPUTE

    • 0 Comments
    It’s been a busy summer.  I got back from vacation and have been hard at work on new features for a future version of SQL Server.  You can always still send me questions about the existing product, of course, and I will answer them here (conorc...
  • Conor vs. SQL

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

    • 1 Comments
    I received a question from a customer today about query plan choice for a parameterized query - specifically that different plans get picked based on where the plan is located, and sometimes one might be better than another.  Apparently, for their...
  • Conor vs. SQL

    Conor vs. Recompiles, part 2

    • 2 Comments
    Thanks to those of you who replied to my previous post.  I spent the last week or so talking with customers, coworkers, and looking at various applications to see how recompiles are modeled today in their applications.  At a high level, SQL...
  • Conor vs. SQL

    Conor vs. Recompiles

    • 2 Comments
    I have a question for you guys about how do you force a recompile for a single query today?   There are a lots of different ways that one could cause the system to recompile a query: a) sp_recompile <object used in a query> b)DBCC FREEPROCCACHE...
  • Conor vs. SQL

    Do Filtered Statistics update as frequently as normal statistics?

    • 1 Comments
    I received a question this week about whether filtered statistics update as frequently as regular statistics.  The right way to ask the question is “Do filtered statistics become invalid as frequently as regular statistics?”, as stats are recomputed...
  • Conor vs. SQL

    SQL Server 2008 Internals Book Now Available!

    • 3 Comments
    For those of you waiting for the new "Inside SQL Server" book, it is actually out now.  Kalen decided to give it a name change, and the actual title is "SQL Server 2008 Internals".  I've written a chapter on how the Query...
  • Conor vs. SQL

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

    • 4 Comments
    A customer recently asked our support organization about an unexplained series of range locks that they were seeing on a DELETE to a table with a foreign key. Here is the repro:   1: create table Foo (FooId int not null primary key ) 2: create...
  • Conor vs. SQL

    Conor vs. Indexed View Updates

    • 1 Comments
    (as ANSI NULLs is one of the requirements for indexed views, I thought I’d give you some perspective on why the questions I ask you are useful and interesting to better understand queries and various query operations)   As currently designed, indexed...
  • Conor vs. SQL

    Conor vs. Non-ANSI NULLs, part 1

    • 1 Comments
    I was thinking about indexed views. Well, more specifically, I was thinking about why indexed views are hard to use. One of the reasons that they are hard is that there are just so many restrictions. Anyways, one of the things I'd like to better understand...
  • Conor vs. SQL

    Conor vs. MERGE and PRIMARY KEY collisions

    • 1 Comments
    MERGE is a new operation added in SQL Server 2008. It has all sorts of knobs, bells, and whistles. The primary value of this feature is to collapse multiple query statements into one query statement. Overall, this avoids the “overhead” necessary to run...
  • Conor vs. SQL

    Conor vs. His Printer

    • 1 Comments
    As many of you may know, I work from my house most of the time - I have a nice office that is quiet and I actually find it to be a great way to get stuff done - I have no commute, I don't get interrupted very much, and I have to attend fewer meetings...
  • Conor vs. SQL

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

    • 3 Comments
    Yes, I'm alive. I have been chatting with my wife about the times I need to "go dark" - in this case, I am working on features that I can't discuss yet, other than to say that I am *very* excited to go to work every day.. (well, since I work out of...
  • Conor vs. SQL

    What I learned at PASS - ETL in Queries.

    • 1 Comments
    I attended only a small number of the talks at PASS. I really enjoyed Bob Ward's talk on memory and Paul Randal's talk on DBCC corruption/repair. Otherwise, I spent a lot of time answering questions from customers. LOTS of questions. So many questions...
  • Conor vs. SQL

    PASS in Seattle! W00t!

    • 2 Comments
    I hope to see folks at PASS - please look for me at the Ask the Experts booth for Query Processing/Performance. I'm very interested in hearing about what kinds of ways you are using SQL Server and how we can make the product better! Thanks, Conor
Page 3 of 4 (91 items) 1234