Viewing 15 posts - 6,766 through 6,780 (of 22,219 total)
dwain.c (2/5/2015)
Grant Fritchey (2/5/2015)
Everything Dwain has said so far is spot on.
I am surprised and somewhat relieved that I am not entirely full of crap, despite what others may be...
"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 6, 2015 at 7:55 am
It means that traceflag is not enabled on your system.
"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:13 pm
Thanks for the kind words.
What if you just work on the inner part of the apply query. Can you get that to filter on it's own, either by changing 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
February 5, 2015 at 1:56 pm
OK. Regardless of the logic, just add a step with that logic.
"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 1:01 pm
Then you can individually go through and REVOKE privileges too.
"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:25 pm
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
Viewing 15 posts - 6,766 through 6,780 (of 22,219 total)