Viewing 15 posts - 4,321 through 4,335 (of 22,224 total)
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
Set up auditing. You're in SQL Server 2014. You can use extended events. It won't help you now, but it will help you tomorrow and next week 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 12, 2016 at 6:22 am
wendy elizabeth (10/11/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 11, 2016 at 8:27 pm
Instead of trying to query to retrieve the inserted values, how about using the OUTPUT clause to save them to a temporary table or a table variable and then use...
"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 11, 2016 at 12:08 pm
Check the execution plans for each query to see how they're being resolved.
"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 11, 2016 at 12:05 pm
This is the 2008 forum, so I suspect this won't help, but if you're on 2012 or better, you could look at using SEQUENCE to possibly do what you're looking...
"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 11, 2016 at 12:04 pm
DesNorton (10/11/2016)
Grant Fritchey (10/11/2016)
If you're going to attempt to tune the query, you absolutely have to have the execution plans. There is no way you...
"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 11, 2016 at 8:15 am
rodjkidd (10/11/2016)
Grant Fritchey (10/11/2016)
rodjkidd (10/11/2016)
I'm assuming its easier to take the train for that leg of my trip.
Should I pre book, or is...
"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 11, 2016 at 8:06 am
rodjkidd (10/11/2016)
I'm assuming its easier to take the train for that leg of my trip.
Should I pre book, or is it just 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 11, 2016 at 7:25 am
Jeff Moden (10/10/2016)
drew.allen (10/10/2016)
Brandie Tarvin (10/10/2016)
Grant Fritchey (10/10/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 11, 2016 at 7:24 am
What everyone else has said, plus.
If you're going to attempt to tune the query, you absolutely have to have the execution plans. There is no way you can poke your...
"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 11, 2016 at 6:28 am
Viewing 15 posts - 4,321 through 4,335 (of 22,224 total)