Viewing 15 posts - 631 through 645 (of 22,219 total)
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
I'm a fan of C#.
"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 19, 2023 at 1:39 pm
You can download a copy of SQL Server Developer Edition for free. Or, better still, install Docker and simply get a SQL Server container, no installation required. Then, take 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 19, 2023 at 1:37 pm
You have a couple of options, neither of which is straight to a table.
First, you can output a text only execution plan. No XML. No graphical whatever. You can 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 19, 2023 at 1:32 pm
Unless you're simply building dynamic SQL on the fly, 100%, there's no way to do this in PostgreSQL. If you choose to do dynamic SQL, understand, depending on what and...
"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 18, 2023 at 1:19 pm
I think you're going to have to build a service on your own. I'm not aware of a cross-database service like this, let alone on AWS.
"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 18, 2023 at 1:16 pm
"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 17, 2023 at 12:18 pm
Nice piece Grant! My thought is that there is always something to be learned, knowing two languages might help in learning the third one, chemistry and physics can aid...
"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 17, 2023 at 12:18 pm
Spot on I say - anything that keeps the grey matter moving is a good idea. Especially if it involves problem solving. G1GKU.
We'll have to meet on the air...
"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 17, 2023 at 12:16 pm
Viewing 15 posts - 631 through 645 (of 22,219 total)