Viewing 15 posts - 631 through 645 (of 22,227 total)
No. If you have size cleanup enabled, it'll clean up when it runs out of room, not wait the 7 days first.
You get a time-based cleanup and a size-based cleanup....
"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
January 31, 2023 at 2:03 pm
Since you can do a backup and a restore, you can do log shipping. If you're looking for a way to do this to MI with minimal downtime, that's generally...
"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
January 31, 2023 at 1:10 pm
No matter what, you'll have to do data cleansing, scripts or tools, that much is necessary. Generally, following data cleansing, I rebuild the indexes and then shrink the database, 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
January 31, 2023 at 1:09 pm
I'm with Phil, probably your best bet is a trigger. Here are the docs. You want to look at the DML triggers and, probably, an AFTER trigger, meaning, after...
"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
January 31, 2023 at 1:00 pm
The one I've been basing my own advice from is years old, by Brad McGehee. Frankly, I did a search, and I can't find it. That stinks, because lots 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
January 30, 2023 at 7:53 pm
what could be good and economical option on AWS ?
If you're going to run on AWS, I'd start by experimenting with AWS RDS. See how that works for 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
January 30, 2023 at 5:23 pm
Ahhhh.... PLE.
I'm to the point where I actively dislike this metric. Not because it's problematic in and of itself. Instead, because of that doggone perpetual bit of "knowledge" that 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
January 30, 2023 at 2:58 pm
I haven't done it, so there's that.
However, based on the documentation, yeah, it should be possible. That's not saying it is. But it really should be.
I'd suggest a few more,...
"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
January 30, 2023 at 2:30 pm
Every single test I've seen over the last, almost 20 years, suggests, with the exception of Columnstore indexes, REORGANIZE is a complete waste of processing power and time. Just don't...
"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
January 30, 2023 at 2:27 pm
Prepping non-production environments can be a lot work. Script the heck out of it. And yeah, there is a command you can use, SHRINK. I don't recommend it for...
"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
January 30, 2023 at 2:24 pm
With size based cleanup set to auto, it'll ignore the 7 day limit and clean up the data based on the size.
EDIT!
But, if it doesn't hit the size limit, then...
"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
January 30, 2023 at 2:17 pm
#SQLHelp is pretty much what it says, "Hey, I could use some help on SQL Server." And that's all it's for. Yeah, sometimes people try to use it advertise 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
January 30, 2023 at 1:42 pm
Are you sure about the "normal people" part? I mean, that group of speakers includes me, so...
Ha!
I believe this stuff, communication with humans, is just hard. We all struggle. Fact...
"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
January 27, 2023 at 12:16 pm
It sounds like you're describing Database DevOps. Basically, code goes into source control. You can run a linter through it there, or automatically later. Set up continuous integration 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
January 25, 2023 at 5:03 pm
Nice one!
Welcome, again, to the team. Great to have you 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
January 23, 2023 at 2:52 pm
Viewing 15 posts - 631 through 645 (of 22,227 total)