Viewing 15 posts - 5,026 through 5,040 (of 22,219 total)
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
RonKyle (3/3/2016)
But if you keep this in one table you lose a lot of data integrity control from the database side. You now have to allow null and move the...
"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:36 am
I'm with Sean. I would absolutely normalize this data. There are simply tons and tons of reasons why. Let's start with the simplest, ensuring that every single spelling of the...
"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:34 am
If all you want is the structure, here's another vote for using the DACPAC. However, I'm with Steve (on multiple levels, I work with him), that if you need to...
"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:27 am
Best approach would to create a backup file using the BACKUP command, and then restore that to another location. From there, do whatever you want, but start with the backup....
"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:24 am
Without seeing the execution plan to understand how the optimizer is resolving the query, it's really hard to know. It's possible that it chose a Nested Loops when a Hash...
"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:21 am
Viewing 15 posts - 5,026 through 5,040 (of 22,219 total)