Viewing 15 posts - 6,751 through 6,765 (of 22,219 total)
Ed Wagner (2/17/2015)
Steve Jones - SSC Editor (2/17/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 17, 2015 at 11:25 am
I don't think there's a way to query Hadoop from SQL Server yet. I know they're working on it. In the meantime, there is a connector for SSIS.
"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 17, 2015 at 9:30 am
Neither Full nor Differential backups will remove completed transactions from the log. You must use Log backups, not shrinking. In addition to Gail's link, here's another[/url].
"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 17, 2015 at 6:57 am
Yeah, I'd think the person that just lost their work might be on board now.
It can be difficult to get across the idea of treating a database like code, 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 17, 2015 at 6:53 am
Start using source control for database development in the same way as app dev. That's the best way to get things done and you can easily recover from problems like...
"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 17, 2015 at 5:20 am
Or extended events. You can also use those in 2008 and greater for monitoring.
"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 17, 2015 at 5:18 am
Assume the right answer is always in the Perfmon Counters themselves and anything else is an interpretation on top of it and make allowances accordingly. Not a great answer, 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 17, 2015 at 4:46 am
The DMV is not the performance counter. It's just a view on top of them. It might not resolve in the same way as going directly to the performance counters...
"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:24 am
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
Viewing 15 posts - 6,751 through 6,765 (of 22,219 total)