Viewing 15 posts - 646 through 660 (of 22,219 total)
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
Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on one 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:43 pm
I do like the attempt at making things accessible. However, I agree, it's not working well enough with the current level of technology.
"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 1:23 pm
You could get away with using the older version, yes. I wouldn't. But you could. Stuff has been added, not taken away.
"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 1:18 pm
Honestly, no way to be certain. While I enjoy working with the AWS technology, AWS billing is insane. Despite deleting everything that I can find on one of my accounts,...
"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 1:17 pm
The first execution time is stored with the query, and isn't the start time. Instead, it's the time of the first execution of that query. That value could be weeks...
"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 10, 2023 at 12:23 pm
Since the memory allocation is based initially on the query, database objects, and the statistics on all those, put together through the query optimization process, you can see exactly 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
January 10, 2023 at 12:20 pm
As someone without a computer science degree or any certifications of any kind (except for a couple back in 1995, which are maybe a tad out of date at this...
"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 10, 2023 at 12:16 pm
It 100% depends on what code you have implemented. Yes, there are changes between RDS 11 and 14 in PostgreSQL. You will need to test your system and your code....
"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 10, 2023 at 12:09 pm
Viewing 15 posts - 646 through 660 (of 22,219 total)