Viewing 15 posts - 2,461 through 2,475 (of 22,227 total)
Did the recovery model get changed and the logs are now huge?
"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
July 29, 2019 at 12:15 pm
Just piling on here.
When comparing the performance between two systems, we have to know that every possible thing is identical before we can say "See, SystemA is sucky and SystemB...
"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
July 29, 2019 at 12:11 pm
Yes. If anything has changed in the structures such that the forced plan is no longer valid, it'll just get ignored.
"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
July 29, 2019 at 12:07 pm
I strongly recommend just focusing on the point in time recovery as your mechanism. It's easy to set up. Completely supported in every way. You won't have to do anything...
"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
July 29, 2019 at 11:19 am
Grant Fritchey wrote:Restore to a point in time. That's all you have to do.
Now THERE's an idea!!! That's why they pay you the big bucks!
Whoa! Hold on a sec....
"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
July 26, 2019 at 6:48 pm
Restore to a point in time. That's all you have to do.
"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
July 26, 2019 at 6:43 pm
You can't take a full backup without transactions. It's fundamental to the recovery aspect so that it can successfully restore without corrupting the database. Not only do can you 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
July 26, 2019 at 12:24 pm
Grant Fritchey wrote:You're all still here? Go home. (btw, hate that movie, but it's a good quote)
I enjoyed the movie. Too bad you hated it.
...
"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
July 23, 2019 at 1:39 am
You're all still here?
Go home.
(btw, hate that movie, but it's a good quote)
"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
July 22, 2019 at 12:35 pm
You're all still here?
Go home.
(btw, hate that movie, but it's a good quote)
"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
July 22, 2019 at 12:34 pm
If I misunderstood, I apologize.
What you're saying you want is a separate database to use for reporting. That separate database will consist of data from a bunch of other databases...
"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
July 22, 2019 at 12:28 pm
This is a problem I am going to have to deal with soon. In most of our dev data, it doesn't need to be realistic data and our options...
"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
July 11, 2019 at 5:19 pm
Have you looked at Dynamic Data Masking in SQL Server? https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-2016 Not sure what you mean by "custom built scripts". You don't need to write any extra scripts 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
July 11, 2019 at 1:15 pm
My vote is for Redgate Data Masker. It's an amazing tool. Also, great integration with SQL Clone. Together, they make a provisioning tool for non-production environments.
"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
July 11, 2019 at 12:36 pm
This question got asked in two places (btw, please don't do that). I answered on the other one with this:
Here is one article and here is another. Between...
"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
July 11, 2019 at 11:20 am
Viewing 15 posts - 2,461 through 2,475 (of 22,227 total)