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
February 2012
(1)
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)
MSDN Blogs
>
Conor vs. SQL
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
Conor vs. SQL
Conor vs. window functions, sequence/ranking functions order-of-operations
Posted
6 days ago
by
Conor Cunningham [MSFT]
0
Comments
We had a customer issue today that ended up being by-design but was confusing enough that I offered to write up a blog post so that people could reference it in the future. It boils down to the question “when should ROW_NUMBER() be computed in a...
Conor vs. SQL
Conor vs. SqlBits Spring 2012
Posted
9 days ago
by
Conor Cunningham [MSFT]
0
Comments
For those interested, I will be speaking at the SqlBits conference in London, UK at the end of March. I’ll be giving the Saturday keynote (on the new Batch processing engine in SQL 2012 used with Column Store indexes) and 2 other talks (one on Data...
Conor vs. SQL
Conor vs. SQL Azure Resource Usage
Posted
24 days ago
by
Conor Cunningham [MSFT]
0
Comments
For those of you watching SQL Azure, you probably have noticed that it releases more frequently than regular SQL Server. There was a release in late November/early December (it is complicated since the installation of the new software is done largely...
Conor vs. SQL
Conor vs. ColumnStore Index Stats
Posted
1 month ago
by
Conor Cunningham [MSFT]
0
Comments
I haven’t posted much on the new SQL Server 2012 features yet, but I’m going to start doing so soon. I’ll also be speaking about them at upcoming conferences. We have an exciting new index type in SQL Server 2012 that is column-oriented...
Conor vs. SQL
Conor vs. Distributed Query Provider Hints
Posted
1 month ago
by
Conor Cunningham [MSFT]
0
Comments
(I promised I’d write more ) Today I will talk a bit about Distributed Query (DQ), a feature that lets you query across databases/servers. I’ve previously posted an academic paper we wrote on the subject some time back ( http://citeseerx.ist.psu...
Conor vs. SQL
Conor vs. SQL Azure/SQL Server 2012
Posted
1 month ago
by
Conor Cunningham [MSFT]
2
Comments
I’m not one for New Year’s Resolutions, but I am going to try to blog a bit more. It’s hard to describe working at Microsoft, especially as one gets more senior. There are lots of really smart people. There’s an ability to work on problems...
Conor vs. SQL
Conor vs. Extended Events
Posted
1 month ago
by
Conor Cunningham [MSFT]
0
Comments
I have been playing with the XEvent feature in SQL 2012 (RC0) and there are a few gotchas that I hit. I figured I’d post them up here so that others could learn from my experiences. I was trying to do something pretty simple – get the % Processor...
Conor vs. SQL
Conor vs. Synergija Slide Decks
Posted
3 months ago
by
Conor Cunningham [MSFT]
0
Comments
I had a great time visiting Belgrade last week. I’d like to thank everyone who attended one of my talks and I wanted to post up the slide decks for those who would like to see them. One talk was on the new SQL 2012 ColumnStore index feature...
Conor vs. SQL
Conor vs. Sinergija 2011
Posted
4 months ago
by
Conor Cunningham [MSFT]
7
Comments
As a professional announcement, I will not be speaking at PASS this year (nor will I be at the conference). Instead, I will be in Belgrade, Serbia the following week to speak at the Sinergija 11 conference. I’ll be doing a talk on the new...
Conor vs. SQL
Conor vs. Max Server Memory
Posted
4 months ago
by
Conor Cunningham [MSFT]
1
Comments
Question (paraphrased): “Conor, does changing the max server memory settings always empty the plan cache on SQL 2005 and 2008?” Answer: yes, this is what happens and what is supposed to happen. One of the inputs to the optimizer is...
Conor vs. SQL
Conor vs. SQL Saturday Austin
Posted
4 months ago
by
Conor Cunningham [MSFT]
0
Comments
I'll be talking about one of the new things our team has been develping this Saturday at the SQL Saturday event in Austin ( http://www.sqlsaturday.com/97/eventhome.aspx) on the new ColumnStore index being added in the upcoming release of SQL Server. It...
Conor vs. SQL
Conor vs. Parallel Execution Plan Contexts/Runtime Instances
Posted
7 months ago
by
Conor Cunningham [MSFT]
0
Comments
I’ve received a question about parallel execution plans from a customer. ( http://technet.microsoft.com/en-gb/library/cc966425.aspx ) Execution contexts for parallel plans are not cached. A necessary condition for SQL Server to compile a parallel query...
Conor vs. SQL
Conor vs. SQLBits 2011 Brighton
Posted
10 months ago
by
Conor Cunningham [MSFT]
0
Comments
Here is the slide deck from my presentation at SQLBits Friday in Brighton file I had a great time at SQLBits, even though I had to leave early. Thank you to everyone who attended the talk and to those who asked questions and gave me feedback...
Conor vs. SQL
Conor vs. SQLBits (United Kingdom)
Posted
10 months ago
by
Conor Cunningham [MSFT]
0
Comments
I will be in Brighton, England this upcoming Friday where I will be speaking at the SQLBits conference. I plan to give a talk that goes deep into how many SQL Server processes Update queries (Insert, Update, Delete). So, if you’ve ever wanted...
Conor vs. SQL
Conor vs. Map-Reduce vs. Databases
Posted
11 months ago
by
Conor Cunningham [MSFT]
1
Comments
I found this paper interesting, so you might too. It covers some of the differences between parallel database systems and map-reduce style computation: http://database.cs.brown.edu/papers/stonebraker-cacm2010.pdf Happy Querying! Conor
Conor vs. SQL
Conor vs. Views/Tables
Posted
over 1 year ago
by
Conor Cunningham [MSFT]
2
Comments
I received an email from a reader this weekend that has a lot of different questions, but one of the main questions related to the difference between views and base tables in SQL Server’s plan generation process. ie if I have a view “select * from...
Conor vs. SQL
Conor vs. How I got into computers…
Posted
over 1 year ago
by
Conor Cunningham [MSFT]
2
Comments
I thought I’d do a small post about some of the reasons I got into computers since I’ve randomly had a few opportunities to revisit them. Tron 2 came out recently, reminding me of the original movie. Additionally, I went home for the holidays...
Conor vs. SQL
Conor vs. more SARGable predicates
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
7
Comments
I got another question in the mail this week from another reader: Hi Conor Thanks for an interesting blog. Maybe you have the answer to this question: Why I SQL Server having performance problems with these types of expressions: --------------...
Conor vs. SQL
Conor vs. Join Search Space
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
0
Comments
I received a question this week from a reader about how SQL Server determines the join order if there are more than 6 joins in a query. There are a lot of details about how SQL Server’s optimizer works here, and some of them are beyond the level of detail...
Conor vs. SQL
Conor vs. Row Growth in Read Committed Snapshot Isolation
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
0
Comments
At PASS last week, I was asked about fragmentation caused by RCSI when a row is first converted to use RCSI. I talked to some people in the team and found that one of my colleagues had already written a nice blog entry about it. http://blogs.msdn.com...
Conor vs. SQL
Conor vs. PASS (Slide Decks)
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
4
Comments
I had a great time at PASS last week and got to talk to a lot of wonderful customers- thank you! As promised, here are the decks: Update Talk Performance Troubleshooting Talk Happy Querying! Conor
Conor vs. SQL
Conor vs. PASS
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
3
Comments
It’s one of the most exciting weeks of the year to be a SQL Server junkie – PASS is this week in Seattle! I’m giving a talk on the many details of Update queries. It will cover the various operators and how they work, why the plan shapes look the...
Conor vs. SQL
Conor vs. PASS (November in Seattle)
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
0
Comments
A note to let you know that I will be at PASS this year and plan to give two talks (one in collaboration with a colleague of mine on the QP). One will be a 500 level talk on how Update queries work – lots and lots of gory details. The other will...
Conor vs. SQL
Conor vs. Optional Parameters Redux – LIKE %
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
0
Comments
A question from a reader (thank you, Price, for sending it in). This is a follow up to my prior post on Optional parameters http://blogs.msdn.com/b/conor_cunningham_msft/archive/2010/04/22/conor-vs-optional-parameters.aspx . The question is whether...
Conor vs. SQL
Conor vs. Updates – Talk (for those of you in Austin)
Posted
over 2 years ago
by
Conor Cunningham [MSFT]
4
Comments
I am giving a talk tomorrow (Tuesday) night at the Austin PASS group on how Update Queries are processed/optimized in SQL Server. The talk will be at the Microsoft office in Austin (which recently moved). More details can be found at the CACTUS...
Page 1 of 4 (77 items)
1
2
3
4