Viewing 15 posts - 10,681 through 10,695 (of 22,219 total)
It sounds like it might be bad parameter sniffing. When the query is running correctly, get a copy of the plan out of cache & store it on the side...
"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
June 26, 2012 at 1:12 pm
SQLKnowItAll (6/26/2012)
Grant Fritchey (6/26/2012)
"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
June 26, 2012 at 12:56 pm
WayneS (6/26/2012)
SQLRNNR (6/26/2012)
Ick - that sucks.
I'm curious about what is being done to ensure that something like this doesn't happen...
"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
June 26, 2012 at 12:55 pm
Brandie Tarvin (6/26/2012)
Grant Fritchey (6/26/2012)
WayneS (6/26/2012)
I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?
Sorry....
"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
June 26, 2012 at 9:16 am
Oh, and a nice horror story for you all[/url].
"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
June 26, 2012 at 8:56 am
WayneS (6/26/2012)
I'll be up in the Boston area (Dedham) this weekend... any Threadizens up that way want to get together? Maybe lift a cold one somewhere?
Sorry. I'll be down in...
"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
June 26, 2012 at 8:53 am
Not enough information to tell you precisely what the solution might be. Is the disk you moved the storage to in the exact same configuration and speed as the disk...
"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
June 26, 2012 at 7:47 am
Again, not knowing what's happening inside that procedure, I can't definitively say that yes, you can eliminate the cursor. But I'm still very strongly suggesting it.
"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
June 26, 2012 at 6:25 am
rahuldhawan2007 (6/26/2012)
i'm new to sql sever. i have few queries
1. what is composite key in a database
2. what is a candidate key
3. what is difference between varchar and nvarchar...
"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
June 26, 2012 at 6:22 am
While there have been no service packs, they just released Cumulative Update #2. I strongly recommend installing it.
"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
June 26, 2012 at 4:48 am
Assuming we're talking about a data file and not a log file, something had to have filled that space. Do you have load processes or queries that use tables for...
"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
June 26, 2012 at 4:47 am
The majority of people do, but it's not a guaranteed approach.
"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
June 26, 2012 at 4:45 am
You're right, every organization attacks that differently. The best documentation I've seen for laying out roles & responsibilities is an older book called "Database Administration" by Craig Mullins. It's still...
"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
June 26, 2012 at 3:58 am
Without seeing & testing the code, it's hard to make a definitive answer. But based on what you've said, yes, I suspect strongly that the cursor is going to affect...
"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
June 26, 2012 at 3:50 am
I only do a little bit of consulting. I know that others do more.
"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
June 25, 2012 at 10:50 am
Viewing 15 posts - 10,681 through 10,695 (of 22,219 total)