Viewing 15 posts - 8,806 through 8,820 (of 22,219 total)
Koen Verbeeck (2/28/2014)
Grant Fritchey (2/28/2014)
"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 28, 2014 at 4:21 am
It's pretty unusual to only ever see IO related waits. But yeah, assuming the data you're providing is correct and you only ever see about 20 seconds of waits within...
"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 28, 2014 at 4:08 am
If it's at the last step its dealing with all the logs, rolling forward or rolling back transactions. That can take a while.
Have you looked at sys.dm_exec_requests to see if...
"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 28, 2014 at 4:04 am
And if you need to you can use ASC or DESC to directly control the sort order of ORDER BY, but ASC, or ascending, is the default behavior.
"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 28, 2014 at 3:58 am
If you really want to see how intellisense ought to work, check out Red Gate SQL Prompt[/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 28, 2014 at 3:55 am
Koen Verbeeck (2/27/2014)
"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 27, 2014 at 4:33 pm
Since tempdb is a total dumping ground, I'd be seriously hesitant to use it in this fashion. I'd look at some other mechanism for caching this common data, possibly not...
"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 27, 2014 at 8:26 am
You can go to zero free space if you want. There's not magic "acceptable" answer. The issue is, why do you need to shrink the database? Was there a broken...
"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 27, 2014 at 8:21 am
pmadhavapeddi22 (2/27/2014)
I would like to gain performance also 🙁Thanks for the reply
You have to then look at the query plan to determine where things are slowing down and how 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 27, 2014 at 8:18 am
A much, much, less accurate mechanism would be to capture the information from sys.dm_exec_query_stats. You can see the last executed date there. That will show you what has been called...
"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 27, 2014 at 8:13 am
sqldriver (2/27/2014)
Grant Fritchey (2/27/2014)
Best practice is, 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 27, 2014 at 8:06 am
I've never found Intellisense to work adequately. Another tool to try is SQL Prompt[/url] from Red Gate Software.
"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 27, 2014 at 6:28 am
Just remember that any of the conversions can prevent the use of statistics which makes the possibilities of scans on the data much higher.
Best practice is, like to like comparisons...
"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 27, 2014 at 6:25 am
Just remember that enforcing referential constraints doesn't just ensure good, clean data. You also get performance enhancements when the query optimizer knows that foreign key constraints are in place and...
"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 27, 2014 at 6:23 am
You've pretty much outlined what SSIS was built for. But, there's no automatic way to do it. You'll have to build the processes by hand.
"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 27, 2014 at 6:18 am
Viewing 15 posts - 8,806 through 8,820 (of 22,219 total)