Viewing 15 posts - 5,026 through 5,040 (of 22,224 total)
But, what version is the SSMS tool that you're using on both?
"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
March 4, 2016 at 2:24 pm
jasona.work (3/4/2016)
WayneS (3/4/2016)
jasona.work (3/4/2016)
To anyone who has gone on any of the previous SQL Cruises, if you brought...
"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
March 4, 2016 at 8:55 am
And then the last statement is usually RESTORE ... WITH RECOVERY so that the process concludes.
"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
March 4, 2016 at 8:45 am
RonKyle (3/4/2016)
"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
March 4, 2016 at 8:39 am
The added cost is only for the SOs cruise. There's no added cost for the SO to be registered with the group and take part in the social aspects of...
"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
March 4, 2016 at 8:31 am
pietlinden (3/4/2016)
"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
March 4, 2016 at 8:29 am
Orlando Colamatteo (3/4/2016)
Igor Micev (3/4/2016)
Grant Fritchey (3/4/2016)
Instead of messing with a custom script, I'd just use one that is pre-built. Minion Reindex [/url]is my current favorite.
Hi Grant,
Can you put here...
"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
March 4, 2016 at 5:52 am
RonKyle (3/4/2016)
I have to agree with Sean and Grant. You can get great performance out of a normalized structure and the integrity is there in the design. Moving the integrity...
"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
March 4, 2016 at 5:49 am
In addition to the DMVs exposed through sp_whoisactive, you need to be focused on wait statistics[/url]. That tells you what is literally causing the server to run slow.
"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
March 4, 2016 at 3:39 am
Instead of messing with a custom script, I'd just use one that is pre-built. Minion Reindex [/url]is my current favorite.
"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
March 4, 2016 at 3:36 am
Rereading the original post again, this data should be normalized. It's clearly relational based on the example. It's collected in a series of stages. Some of the data is required,...
"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
March 3, 2016 at 5:23 pm
Tom Van Harpen (3/3/2016)
Grant Fritchey (3/3/2016)
The job owner, but which account owns the step?
Ok i had nothing specified for the run as user option on the advanced tab.
There is...
"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
March 3, 2016 at 12:42 pm
The job owner, but which account owns the step?
"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
March 3, 2016 at 12:13 pm
Lowell's answer is excellent. Just understand the logic he used. He's taking 24 hours off the time. You could also just take one day off the time using the same...
"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
March 3, 2016 at 11:44 am
The account that runs the backup has to have permission to run the backup and it has to have permission on where the backup is going. If you create a...
"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
March 3, 2016 at 11:42 am
Viewing 15 posts - 5,026 through 5,040 (of 22,224 total)