Viewing 15 posts - 211 through 225 (of 22,224 total)
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
If I answer the questions, what does the job pay and when do I start?
Cause you wouldn't take my answers to those questions and submit them as your own 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
July 1, 2024 at 1:17 pm
Bugs. Natural and inevitable. And probably perpetual.
I didn't trust virtual machines when we first started using them. And, we had problems. Then, over time, they just became a standard. I...
"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 1:11 pm
What? My opinion can't possibly be wrong. HA! Totally kidding.
Yeah, hey, honest people can certainly disagree. Without a doubt our experiences and the lessons we get from the vary. It's...
"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 1:03 pm
Viewing 15 posts - 211 through 225 (of 22,224 total)