Viewing 15 posts - 211 through 225 (of 22,227 total)
There isn't a single correct answer to this. Here's my list of "I'm gonna need this" software:
SQL Server Management Studio
Azure Data Studio
VS Code
Git
Docker
Redgate Toolbelt (yes, I work for them, but...
"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
July 15, 2024 at 1:56 pm
If you really want performance, create a wrapper proc that determines if you're doing an INSERT/UPDATE/DELETE and then a proc for each. MERGE generally stinks on performance. Period.
"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
July 12, 2024 at 12:44 pm
Happens to everyone. No worries.
"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
July 11, 2024 at 4:04 pm
Yeah, I was thinking something similar. I wonder if it's the unicode string that's causing the 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
July 10, 2024 at 1:00 pm
Database projects are more than a little difficult to work with in source control, and I do source control my databases. So, external tools are generally better. For free, when...
"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
July 10, 2024 at 12:58 pm
Bad news is, probably not. I mean, do run validations on all your hardware, because that could be the issue. However, data corruption can be from external sources. Power surges...
"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
July 10, 2024 at 12:56 pm
Thanks Grant
I accept your point - why is the system giving me a "select permission denied" when using the scalar variable in a select statement, when the user is...
"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
July 9, 2024 at 3:32 pm
The key difference is a result set. Scalar functions return a value, not a result set. So they're not being "selected" from, they're being executed.
"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
July 9, 2024 at 12:43 pm
That sure doesn't sound normal. And this is related to the initial 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
July 8, 2024 at 3:28 pm
Then you have to get a license to run Standard.
"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
July 2, 2024 at 2:15 pm
Developer edition is the best "free" one you're going to get.
"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
July 2, 2024 at 12:05 pm
Sounds like you're trying to enabled Query Store on the secondaries. That's only available in SQL Server 2022, not 2019. Here you go.
"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
July 2, 2024 at 12:05 pm
A) Testing is your buddy. Don't take anyone's word for it. Test it.
B) Probably not. In fact, that's almost the opposite of what I'd want to do. Presumably, guessing 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
July 2, 2024 at 12:01 pm
If I answer the questions, what does the job pay and when do I start?---> I Just need a second opinion to make my self much better while answering...
"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
July 2, 2024 at 11:14 am
Yep. Could be a real problem. No denying it. But, I tend towards 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
July 1, 2024 at 6:35 pm
Viewing 15 posts - 211 through 225 (of 22,227 total)