Viewing 15 posts - 6,766 through 6,780 (of 22,226 total)
Word on the street is that a new cert for 2014 will be out very soon. But, as Gail says, it's not here yet.
"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 16, 2015 at 4:22 am
KGJ-Dev (2/5/2015)
thanks grant and please suggest me if it not enable will it affect performance. How drastically it affect the performance?
I have not seen it have a negative impact on...
"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 16, 2015 at 3:28 am
Lynn Pettis (2/15/2015)
TomThomson (2/14/2015)
Lynn Pettis (2/14/2015)
TomThomson (2/14/2015)
Eirikur Eiriksson (2/7/2015)
TomThomson (2/7/2015)
Grant Fritchey (2/5/2015)
Really? Yankees fans? Are they even human?Usually not - they're mostly American.
Tom, must say that I find this comment...
"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 16, 2015 at 3:26 am
Lynn Pettis (2/15/2015)
... Mark one off, 12 days on the calendar to go. 12 days on the calendar to go, 12 days to go, ...
Almost down to the single digits.
WHOOOP!!!!
"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 16, 2015 at 3:19 am
kkp40 (2/13/2015)
I would like to read about how to use the execution plans to understand what to change in my sql-query, or in the table, to make it better.
I can...
"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 15, 2015 at 5:47 am
I agree. This looks like standard parameter sniffing gone wrong. It's always about the data and the data distribution. The parameter values passed from one create a plan for retrieving...
"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 7, 2015 at 3:18 am
Prior to extended events, I had trace running 24/7 on a lot of systems too. It's work to deal with the data generated, but it's a great way to gather...
"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 8:06 am
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
Viewing 15 posts - 6,766 through 6,780 (of 22,226 total)