Viewing 15 posts - 12,286 through 12,300 (of 22,219 total)
Roy Ernest (6/16/2011)
Grant submitted a session on how to write good abstracts. 🙂 Maybe we can ask him to write an article up on it. 🙂
Yeah, but that session got...
"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 16, 2011 at 6:56 am
The thing is, you're running 2005 and 2000. They are two totally different optimizers. There were a number of upgrades in the engine as well as changes, stuff was fixed,...
"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 15, 2011 at 9:03 pm
WayneS (6/15/2011)
"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 15, 2011 at 8:58 pm
ALZDBA (6/15/2011)
jcrawf02 (6/15/2011)
Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing,...
"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 15, 2011 at 1:37 pm
I've nominated a couple of people from this list and, as far as I know, nothing has come of it. I must write bad recommendation letters.
"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 15, 2011 at 12:05 pm
Cost is an estimate generated by the optimizer. You can't control except by making the plan simpler.
As to why the query would run faster because you removed quotes, I have...
"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 15, 2011 at 11:26 am
ALZDBA (6/15/2011)
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Congratulations, Grant.
Apparently you have been very active today, now you're already at :
Points: 10,881, Visits: 21,283
Nah, that's points. I was...
"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 15, 2011 at 7:06 am
GilaMonster (6/15/2011)
Grant Fritchey (6/15/2011)
"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 15, 2011 at 7:04 am
You could create a hash column as a calculated column next to your varchar(max) and then put a unique constraint on the hash column. It's unlikely to be perfect, but...
"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 15, 2011 at 5:58 am
That's 10,000 posts, done.
Wait, now it's 10,001.
"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 15, 2011 at 5:49 am
In a perfect world, 15% is probably workable, but with unexpected data loads, badly performing apps, failed maintenance jobs, sunspots, alien invasion... I prefer to run 30% free, minimum, unless...
"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 15, 2011 at 5:30 am
If a query is executing, it has an execution plan. The plan comes first. And it gets stored in the plan cache prior to execution as well. If that process...
"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 15, 2011 at 5:26 am
Looks like parallelism might be getting you. The cost for the plan is only 3. What is your cost threshold for parallelism? Default should be 5. Try setting it up...
"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 15, 2011 at 4:58 am
Instead of checking the error log every two hours, why don't you just have the errors forwarded to you directly. Then you know about them when they happened rather than...
"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 15, 2011 at 4:51 am
The thing is, it's likely to reduce deadlocks, but it's unlikely to eliminate them and it certainly won't prevent them in the future. Best way to avoid or fix deadlocks...
"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 14, 2011 at 4:07 pm
Viewing 15 posts - 12,286 through 12,300 (of 22,219 total)