Viewing 15 posts - 4,306 through 4,320 (of 22,219 total)
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
I was surprised that the developer wasn't fired, but since I also expected to be fired, I sure didn't complain about it.
I guess twenty years ago places were a little...
"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 9:01 am
Brandie Tarvin (10/12/2016)
"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:36 am
BWFC (10/12/2016)
We also need to make sure that these aren't the only backups. Not that they would be...right?
You hope. That's why we verify everything. A little paranoia goes 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 7:51 am
If you have questions, just ask. I'll do what I can to help out. This is a huge topic.
"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 7:46 am
jasona.work (10/12/2016)
Grant Fritchey (10/12/2016)
"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 7:45 am
lindsayscott23 (10/12/2016)
Firstly I hope this question is in the right forum. I usually ask pretty standard TSQL questions, and this is the first time I've really had to think about...
"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 6:56 am
It's not big growth, at all. That's .05gb/day. In 50 days, two months, you'll grow 2.5gb. In 500 days, you'll grow 25gb. Storage currently costs about $0.019/gb. To support almost...
"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 6:33 am
Do you test the backups from your primary production servers? By test, I mean, the full range of tests[/url], including a restore? If so, toss those secondary backups. They're not...
"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 6:27 am
Viewing 15 posts - 4,306 through 4,320 (of 22,219 total)