Viewing 15 posts - 646 through 660 (of 22,227 total)
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
On that note, here's an article that might be of interest to you, Grant.
https://www.smithsonianmag.com/innovation/morse-code-back-looking-ditch-twitter-180981309/
Ha! Yeah, I saw that one. I keep dipping a toe into the CW (proper name...
"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:15 pm
Hey Tom!
I only know of a few people who've moved to 2022. However, none of them have reported any major issues. As you very well know, testing is your buddy,...
"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:13 pm
If you're going through the pain of an upgrade anyway, just go to the latest version. Is 2022 wildly and in every possible way superior to 2019? No. However, 2022...
"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 13, 2023 at 1:51 pm
Honestly, sounds like your query is using too much memory. You either need to tune it so that it performs better (and there really isn't a way to tune BRING...
"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 13, 2023 at 1:49 pm
Sure sounds like a security issue.
"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 13, 2023 at 1:23 pm
With zero details, I've no idea what the answer could be. Any chance of posting code or at least describing what this job does? Write the output to where? What...
"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 12, 2023 at 1:15 pm
Gosh... I wouldn't blame the "current level of technology" for any such complaints that Steve has cited. That's not the issue.
It's not ALL the problem, but it's part 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 11, 2023 at 3:51 pm
Viewing 15 posts - 646 through 660 (of 22,227 total)