Viewing 15 posts - 6,781 through 6,795 (of 22,229 total)
You can use ddl_admin. But, you may also have to give them security_admin in order to set permissions on the procedures they create.
"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
February 5, 2015 at 12:04 pm
3 million rows filtered down to 9 by a late filter... Ouch.
Since you're only going for the first row within the cross apply, why not change that to a simple...
"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
February 5, 2015 at 12:01 pm
Aren't they scheduled through a SQL Agent job? Just add a step to the job to move the files using Powershell.
"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
February 5, 2015 at 11:53 am
It does depend on the query you're running against the DMVs, but, generally, those are very lightweight, so it should be fine. The nice thing about them is that 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
February 5, 2015 at 11:52 am
"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
February 5, 2015 at 11:43 am
Sioban Krzywicki (2/5/2015)
Grant Fritchey (2/5/2015)
Brandie Tarvin (2/5/2015)
I didn't even know this was a thing, 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
February 5, 2015 at 10:30 am
Jack Corbett (2/5/2015)
"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
February 5, 2015 at 9:39 am
Brandie Tarvin (2/5/2015)
So I just got a workplace reminder to wear red tomorrow because of National Red Day[/url].I didn't even know this was a thing, but it is. Wanna participate?
Eh....
"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
February 5, 2015 at 9:37 am
Brandie Tarvin (2/5/2015)
Sioban Krzywicki (2/5/2015)
Grant Fritchey (2/5/2015)
Brandie Tarvin (2/5/2015)
Do you agree...
"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
February 5, 2015 at 7:45 am
Sioban Krzywicki (2/5/2015)
Grant Fritchey (2/5/2015)
Brandie Tarvin (2/5/2015)
Do you agree or disagree...
"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
February 5, 2015 at 7:33 am
If you don't update your statistics the optimizer will make bad choices for your query plans. This can seriously negatively impact performance. So, large database or not, you have to...
"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
February 5, 2015 at 7:09 am
Brandie Tarvin (2/5/2015)
Do you agree or disagree that trick questions are...
"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
February 5, 2015 at 6:47 am
Cody K (2/5/2015)
Yes the graphs are definitely the same. I mean it's not the same row/page but they're all on the same table, same queries, same combination of indexes.
Perfect. Then...
"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
February 5, 2015 at 5:48 am
right, the object definition.
"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
February 5, 2015 at 5:48 am
Yeah, it's really an issue with the servers and their configuration.
But, that's not to say that tuning won't help. Reduce the amount and number of reads you need and then...
"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
February 5, 2015 at 4:51 am
Viewing 15 posts - 6,781 through 6,795 (of 22,229 total)