Site: http://blogs.msdn.com/b/conor_cunningham_msft/ Link: http://blogs.msdn.com/conor_cunningham_msft/rss.xml
by Conor Cunningham [MSFT] via Conor vs. SQL on 3/23/2009 5:28:05 PM
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...(read more) ...
[ read more ]
by Conor Cunningham [MSFT] via Conor vs. SQL on 3/13/2009 6:12:52 PM
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 table...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 2/9/2009 7:45:00 AM
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...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 2/5/2009 5:51:30 AM
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...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 11/26/2008 5:10:00 AM
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...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 11/3/2008 11:50:00 PM
Thank you for everyone who "voted" - a great day to talk about the issues of the day :). After much research, I've found that we live in a divided country. Some of us like triggers. Others wouldn't be caught dead with a trigger and do lots of business...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 10/31/2008 7:15:00 PM
I've gotten a few data points, but I don't think I've had enough yet to complete my sample. I'm still looking for people willing to describe how and where they implement business logic in their database applications. 1. CHECK CONSTRAINTS 2. TRIGGERS 3....(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 10/28/2008 3:50:00 PM
I've been having a conversation with a customer about CHECK constraints and TRIGGERs, and I thought it would be good to survey some of our customers about how people use these features. I'm curious how many people encode business logic validation in CHECK...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 10/24/2008 2:19:00 PM
Today's question comes from a friend I have in Brazil. Please, tell-me one thing, is there any improvement in avoid Implicit Conversions forcing one explicit conversion? Or will QP behind the scenes execute the same SQL using the function CONVERT()? These...(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 7/28/2008 3:39:00 PM
As Microsoft is about to release a new version of SQL Server, I would like to spend some time on upgrades today. We are constantly looking at our product offering to decide what kinds of features to build in the future, and so your input is always interesting....(read more) ...
by Conor Cunningham [MSFT] via Conor vs. SQL on 7/24/2008 2:31:00 PM
I had a question about sample rates for statistics yesterday for SQL Server 200x statistics. Here is my basic rule-of-thumb. 1. If you have no issues with statistics or query plan quality, then you can leave it alone and not think about it. 2. If you...(read more) ...
The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.
