Viewing 15 posts - 11,566 through 11,580 (of 22,224 total)
I'm with Steve. However, this checklist will give you a starting point.
"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 6, 2011 at 6:26 am
Performance on that query should be interesting. By interesting I mean, very, very slow.
Just so you know, LIKE statements with a leading wild card lead to scans with no opportunity...
"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 6, 2011 at 6:24 am
Ninja's_RGR'us (12/5/2011)
Grant Fritchey (12/5/2011)
Ninja's_RGR'us (12/5/2011)
Grant Fritchey (12/5/2011)
Ninja's_RGR'us (12/5/2011)
I'm pretty sure you meantI'm NOT trying to fight with you,
😀
Ah! the joys of not being f2f :hehe:.
Oh crap!
I edited that. Oops....
"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 5, 2011 at 5:34 pm
Ninja's_RGR'us (12/5/2011)
Grant Fritchey (12/5/2011)
Ninja's_RGR'us (12/5/2011)
I'm pretty sure you meantI'm NOT trying to fight with you,
😀
Ah! the joys of not being f2f :hehe:.
Oh crap!
I edited that. Oops. I'm sure 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
December 5, 2011 at 4:46 pm
Ninja's_RGR'us (12/5/2011)
I'm pretty sure you meantI'm NOT trying to fight with you,
😀
Ah! the joys of not being f2f :hehe:.
Oh crap!
I edited that. Oops. I'm sure that didn't help at...
"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 5, 2011 at 11:48 am
nico van niekerk (12/5/2011)
Grant Fritchey (12/5/2011)
nico van niekerk (12/4/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
December 5, 2011 at 11:46 am
nico van niekerk (12/2/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
December 5, 2011 at 11:41 am
Oldman@ds9 (6/22/2010)
I've the similar Problem on by new SQL-Sever, having a lot of freee memory. I still not found a resolution.
I realize this thread is 18 months old, but I'm...
"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 5, 2011 at 7:42 am
nico van niekerk (12/4/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
December 5, 2011 at 5:41 am
The chapter I wrote for the MVP Deep Dives 2 book is all on parameter sniffing "Parameter Sniffing, Your Best Friend in the World, Except When It Isn't." I lay...
"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 4, 2011 at 4:43 am
If you look at sys.dm_exec_requests you can see what the process is currently waiting on. You can also get a link to what locks are being held by the...
"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 4, 2011 at 4:40 am
It's hard to know for sure in these situations without a lot more detail. In general, I'd assume an issue with statistics and/or blocking. You say no other processes were...
"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 4, 2011 at 4:37 am
Let me try:
Hadoop
Ellison
Database Tuning Advisor
Nope. It's broke.
"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, 2011 at 9:04 am
Ninja's_RGR'us (12/2/2011)
Grant Fritchey (12/2/2011)
Ninja's_RGR'us (12/2/2011)
kyle.doouss (12/2/2011)
Some times I use the design mode which then screws up the layout.Is there no way apart from reformatting manually then?
http://www.red-gate.com/products/sql-development/sql-prompt/
I'm glad you brought 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
December 2, 2011 at 6:03 am
Ninja's_RGR'us (12/2/2011)
kyle.doouss (12/2/2011)
Some times I use the design mode which then screws up the layout.Is there no way apart from reformatting manually then?
http://www.red-gate.com/products/sql-development/sql-prompt/
I'm glad you brought it up. I've been...
"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, 2011 at 5:36 am
Viewing 15 posts - 11,566 through 11,580 (of 22,224 total)