Viewing 15 posts - 661 through 675 (of 22,232 total)
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
What are you pricing? Azure SQL Database? Azure Managed Instance, or just Virtual Machines?
(as to the spam, probably not. I see a lot of people ask the exact same question...
"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:07 pm
You're asking about a MySQL database on a Microsoft SQL Server forum... in the Reporting Services section. There is a MySQL section: https://www.sqlservercentral.com/forums/forum/sql-server-and-other-platforms/mysql
You may get much better answers there.
Have...
"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:05 pm
Viewing 15 posts - 661 through 675 (of 22,232 total)