Sign In
Conor vs. SQL
Conor Cunningham's blog on SQL Server, data-driven applications, and pretty much whatever other random stuff he decides to post.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
ANSI
ANSI_NULL
backup
Business Intelligence
Cardinality
CASCADING RI
CHECK
ColumnStore
Data Warehouse
DELETE
Distributed Query
ETL
hints
locking
Optimization
performance
recompiles
SQL
SQL Server
statistics
STOREDPROC
TRIGGER
View
Virtualization
Win2k8
Archive
Archives
April 2012
(1)
February 2012
(3)
January 2012
(5)
December 2011
(1)
October 2011
(2)
September 2011
(2)
June 2011
(1)
April 2011
(2)
February 2011
(1)
January 2011
(2)
December 2010
(2)
November 2010
(3)
September 2010
(2)
August 2010
(3)
July 2010
(2)
May 2010
(1)
April 2010
(7)
March 2010
(1)
February 2010
(1)
January 2010
(2)
December 2009
(1)
November 2009
(1)
October 2009
(2)
August 2009
(3)
June 2009
(1)
May 2009
(2)
April 2009
(1)
March 2009
(2)
February 2009
(3)
January 2009
(2)
November 2008
(4)
October 2008
(4)
September 2008
(1)
August 2008
(4)
July 2008
(5)
April, 2010
MSDN Blogs
>
Conor vs. SQL
>
April, 2010
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Conor vs. SQL
Conor vs. Index Fragmentation in Plan Selection
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
0
Comments
(more SQL Bits questions) Does the SQL Server Query Optimizer consider index fragmentation in plan selection? No, it does not directly care. The optimizer does currently consider the number of pages consumed by the index. So,...
Conor vs. SQL
Conor vs. Left Outer Join Reordering
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
5
Comments
A question from two of the MVPs: Are these two queries conceptually the same? select a.id, b.id, c.id from A left join C on A.id = C.id left join B on A.id = B.id; select a.id, b.id, c.id from A left join B on A.id = B.id left join C on A.id =...
Conor vs. SQL
Conor vs. Index SARGability with complex scalar expressions
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
0
Comments
In my prior post, I introduced the concept of runtime constants. Now let’s take this and apply the concept further to the topic of matching scalar predicates to indexes. I will paraphrase a customer question I was mailed after SQL Bits last...
Conor vs. SQL
Conor vs. Runtime Constant Functions
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
3
Comments
(more questions resulting from SQL Bits – some of these answers will be a bit more terse than my usual verbose self :)) A customer asked a different question and I need to introduce a concept to you before I can answer that question, so I will...
Conor vs. SQL
Conor vs. the Search Framework in SQL Server’s Optimizer
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
1
Comments
I got a few requests for additional topics where one can read about the SQL Server query optimizer’s search framework (which happens to be called Cascades). I will warn you that most of these are academic papers. Some of these use different...
Conor vs. SQL
Conor vs. Optional Parameters
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
2
Comments
One question I received at SQL Bits had to do with a reasonable programming practice that has an unintended performance impact. SELECT <something> FROM T WHERE (@p is NULL or col = @p) This pattern is common and we call it the “optional...
Conor vs. SQL
Conor vs. Icelandic Volcano/SQLBits 6
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
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...
Page 1 of 1 (7 items)