Viewing 15 posts - 4,306 through 4,320 (of 22,227 total)
Chad Crawford (10/18/2016)
Grant Fritchey (10/18/2016)
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite...
"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
October 18, 2016 at 9:04 am
BLOB_EATER (10/18/2016)
Grant Fritchey (10/18/2016)
Evidently stating the obvious when others are stating the opposite is not allowed amongst those...
"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
October 18, 2016 at 6:27 am
Wow, just read the comments on Reddit about a recent blog post... ouch.
Evidently stating the obvious when others are stating the opposite is not allowed amongst those who know what...
"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
October 18, 2016 at 6:16 am
Brandie Tarvin (10/17/2016)
So who else is going to be watching Dirk Gently's Holistic Detective Agency when it comes out?
Read those when I was much younger. Which network is putting them...
"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
October 17, 2016 at 7:02 am
I like Bill's recommendations. The thing is, the more drives you can throw at it, the better. The exception to that is if you're going through a single controller, which...
"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
October 14, 2016 at 6:43 am
jasona.work (10/13/2016)
http://www.ussdetroitlcs7.com/%5B/url%5D
I think it'd be cool to poke around (as much as...
"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
October 13, 2016 at 11:44 am
Hugo Kornelis (10/13/2016)
I may need to redo my reviewing work of your exec plans book after reading that page.. :w00t:
BWA-HA-HA-HA-HA!
<quiet voice>
don't you dare
</quiet voice>
"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
October 13, 2016 at 8:40 am
Big assumption on my part, but aren't you going for something like the situation in this article[/url]? There are examples there of exactly what I mean.
"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
October 13, 2016 at 8:26 am
GilaMonster (10/13/2016)
Grant Fritchey (10/13/2016)
Sean Lange (10/13/2016)
This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context...
"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
October 13, 2016 at 8:20 am
Sean Lange (10/13/2016)
This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or explanation. And...
"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
October 13, 2016 at 8:10 am
Sean Lange (10/13/2016)
This is supposed to be a list of things to do to optimize queries. While some of these are valid most of them lack context or explanation. And...
"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
October 13, 2016 at 8:08 am
You've got two sort operations (including one with a spill to tempdb) in support of a merge join. Despite the estimated costs, I think this is where more of 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
October 13, 2016 at 7:36 am
WhiteLotus (10/12/2016)
Thanks for the feedback . Much appreciatedIt is very cheap ! Can you show me the link about the price / product information ?
Many thanks
I just did a...
"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
October 12, 2016 at 8:57 pm
Further, if you modify the data, INSERT/UPDATE/DELETE, in the table with the foreign key constraint in such a way that the foreign key constraint can't be applied, you either 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
October 12, 2016 at 11:13 am
lindsayscott23 (10/12/2016)
I've been mapping out the current situation, and the next step is to do the same for my proposed solution....
"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
October 12, 2016 at 11:03 am
Viewing 15 posts - 4,306 through 4,320 (of 22,227 total)