Viewing 15 posts - 6,751 through 6,765 (of 22,221 total)
Then all I can suggest is the standard stuff. Make sure you're queries are filtering on criteria where there are indexes. Add indexes if necessary. Update the statistics, possibly using...
"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 12:30 pm
Without the execution plan, nothing but vague guesses are possible.
"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:28 am
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
Viewing 15 posts - 6,751 through 6,765 (of 22,221 total)