Viewing 15 posts - 10,681 through 10,695 (of 22,224 total)
Lynn Pettis (6/26/2012)
And we have another horror story, Already tried repair, rebuild, detach/attach, backup/restore (no backup prior to this error).
Youch! That's a real horror story.
"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 27, 2012 at 3:56 am
Koen Verbeeck (6/26/2012)
Well, I did the best I could.
I 'liked' the book on Amazon, gave it 5 stars and wrote...
"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 27, 2012 at 3:55 am
OK, but I'm still in the dark here. You saw slower performance on a server with slower & fewer CPU? That's kind of normal. If your system was well tuned...
"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:30 pm
SQLKnowItAll (6/26/2012)
Grant Fritchey (6/26/2012)
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 1:25 pm
Hard to know. What's different about the different servers? Is one faster than another, more memory, more cpu, different kinds of disk storage, different settings on the sQL Server instance,...
"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:15 pm
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
Viewing 15 posts - 10,681 through 10,695 (of 22,224 total)