Viewing 15 posts - 16,141 through 16,155 (of 22,219 total)
Gail's already focused on the core of the question, you're only going to see two plans in the cache for a given query (assuming the same parameters, yada-yada).
But, you can...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2009 at 6:48 am
laurav (12/3/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2009 at 6:24 am
What, no video?
Excellent editorial. The link seems to be missing to the T-Mobile story in the UK. Any chance of posting it?
We're working with a tough piece of software. SQL...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2009 at 5:52 am
thefourthdoctor (12/2/2009)
- build the second box
- backup dbs on the first
- restore on the second
-...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 3, 2009 at 5:45 am
After you move the database you need to be sure that you set the compatibility level to 10. You should also update all the statistics on the database.
The safest way...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2009 at 6:45 am
Speaking from a pure paranoia standpoint, I'd want to be able to have both servers online at the same time. That way you can leave your existing system in place...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2009 at 6:42 am
Whatever context SQL Server is running under, it does not have access to that network share. Even if you do, and you're running the command, it doesn't matter, the SQL...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
December 2, 2009 at 6:14 am
When you insert a row, it has to be placed in the correct place in an index. When you do a batch insert of umpty-x number of rows, they also...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 30, 2009 at 8:44 am
Does it have different session id's? I'm just curious if it's opening a second connection to run the query. But yeah, I've seen it before. We had an app that...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 30, 2009 at 8:30 am
Sounds like you're running a cursor. But I'm honestly just guessing without code.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 30, 2009 at 7:54 am
Connection settings differences makes the most sense. Especially the ANSI standard settings. Differences there will absolutely result in different execution plans.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 30, 2009 at 7:10 am
Previously, I just concentrated on blocking stuff out. Lately, I've been listening to music a lot. Neither approach is perfect. I'd love to try out the noise cancelling headphones with...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 30, 2009 at 7:07 am
Since it's a temp table, what does your tempdb look like? Are you possibly seeing a lot of resource contention there? Do you have multiple file groups (and drives) assigned...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 27, 2009 at 5:39 am
RBarryYoung (11/25/2009)
Grant Fritchey (11/9/2009)
...Best thing was showing up late to Buck Woody's session, in a kilt. I sat up front... Sharon Stone was mentioned... 'nough said.
BWAHAAHA!!! OMGROFL! :w00t:
...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 27, 2009 at 5:23 am
GilaMonster (11/25/2009)
Happy normal working week. 😀I'll hold down the fort while all the US people are off stuffing themselves with turkey and whatever else appears on a thanksgiving table.
More apple...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 25, 2009 at 1:38 pm
Viewing 15 posts - 16,141 through 16,155 (of 22,219 total)