Viewing 15 posts - 4,051 through 4,065 (of 22,219 total)
"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 22, 2017 at 10:55 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 22, 2017 at 9:29 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 22, 2017 at 9:27 am
You can query the cache to get aggregate information using sys.dm_exec_query_stats. It won't show individual calls, but will show, over the time the query has been in cache, how much...
"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 22, 2017 at 9:16 am
This is a year old thread. The articles I linked to show how to do exactly what the OP asked for.
Oh, and checked the link to my article....
"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 22, 2017 at 7:11 am
The relationships between RequestOrder, RefNo and RetrievalDetail are very unclear.
As to whether or not there's a link between RequestOrder and Department... I don't know. You tell me. What...
"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 22, 2017 at 6:43 am
Gail has given you step one, RESTORE VERIFYONLY. Here's a link to the command so you can work out how to do it.
Are you sure that...
"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 22, 2017 at 6:38 am
Agreed. Powershell to the rescue. Just script out each step you do manually and work them into Powershell. One step at a time. Test each one.
"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 22, 2017 at 6:36 am
OK, so sp_updatestats uses sampling to create the statistics? Do you also do index rebuilds at any point? These create statistics using full scan. You may just be putting your...
"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 21, 2017 at 12:06 pm
"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 21, 2017 at 11:47 am
The main problem with reading deadlock graphs is that they are incomplete. The batch that contains the UPDATE statement has another 159 lines of code in it. The deadlock victim...
"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 21, 2017 at 5:10 am
SQLRNNR - Monday, February 20, 2017 11:47 AMDang it. It wasn't bought out of midlife crisis. :Whistling:
Mostly.
"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 20, 2017 at 1:05 pm
"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 20, 2017 at 1:05 pm
"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 20, 2017 at 9:24 am
If you lose a decision, do you resort to violence...
"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 20, 2017 at 8:14 am
Viewing 15 posts - 4,051 through 4,065 (of 22,219 total)