Viewing 15 posts - 5,041 through 5,055 (of 22,227 total)
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
Jeff Moden (3/3/2016)
Grant Fritchey (3/3/2016)
Jeff Moden (3/2/2016)
sickb00000y (3/2/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 3, 2016 at 7:23 am
You can't really figure out what the "last" user is without some method of indicating the order of the users. You have to have a date or a sequence number...
"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 6:36 am
Jeff Moden (3/2/2016)
sickb00000y (3/2/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 3, 2016 at 6:31 am
Data is going to grow. You need to be prepared for that. If you want to monitor what's happening on a database, the best tool is extended events. However, 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
March 3, 2016 at 6:30 am
shamshad.ali (3/3/2016)
Can you please let me know how can I test it and share the stats? then we can decided if it is feasible to go ahead?Shamshad
Set up the situation....
"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 4:21 am
Jeff Moden (3/2/2016)
Considering the recent track record for SPs and CUs, you might consider waiting for at least a month before you deploy either.
Oh yeah, I wouldn't recommend deploying 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 2, 2016 at 11:50 am
GilaMonster (3/2/2016)
Grant Fritchey (3/2/2016)
Anycompletedtransactions that are currently in the log are what get backed up.Uncommitted also get backed up.
I always forget that part of how it works....
"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 2, 2016 at 9:44 am
Viewing 15 posts - 5,041 through 5,055 (of 22,227 total)