Viewing 15 posts - 766 through 780 (of 22,219 total)
Just so we're clear, CTFP = Cost Threshold for Parallelism.
And I agree. Changing it from the default value is a must. In addition to picking an arbitrary value (common practice...
"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
October 5, 2022 at 12:55 pm
I'll be there!!
"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
September 30, 2022 at 1:48 pm
I think that's how you have to do it there too. You can't simply upgrade the VM in place. It just doesn't work like that. Once you have a VM,...
"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
September 29, 2022 at 3:08 pm
If you're willing to do an in-place upgrade, it's really simple. Get the media for the Standard (or any other) edition on to the VM (how you do that 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
September 29, 2022 at 12:54 pm
The principal use case would be extensive, many-to-many data structures. If you don't have that, you don't need to sweat it.
"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
September 26, 2022 at 12:13 pm
Sounds good then. As I said, a long time ago, if the tool can meet the RPO & RTO, I'm fine with it.
"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
September 23, 2022 at 12:19 pm
I know this is an old topic but we are using Cohesity 6.6. It now has SQL log backup and Point in time restores. So far I'm liking...
"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
September 23, 2022 at 8:51 am
I think Eddie has it nailed.
However, if you really want the single most solid answers to licensing questions, I'd go to Microsoft, not the forums. After all, they always 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
September 22, 2022 at 5:40 am
You can output to the buffer as a target. However, that's not recommended. It puts more of a load on the system than output to a file. I prefer 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
September 21, 2022 at 6:35 am
More than one plan usually indicates different statistics distributions for the parameters involved in the query. Say, filtering on ID = 42 returns 10,000 rows and filtering on ID =...
"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
September 21, 2022 at 6:30 am
Would some of these free tools be a starting point for someone unfamiliar troubleshooting ?
https://www.idera.com/productssolutions/freetools/
Other companies may have similar tools, and most will also offer free trials 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
September 21, 2022 at 5:38 am
To a degree, the difference between ON & WHERE, can be, but isn't entirely, syntactic sugar. However, what I say is, for clarity sake, put filter criteria in...
"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
September 21, 2022 at 5:29 am
Grant, sorry to be going on about this.
But just to be clear, are you saying that if not for the fact that I'm working with a OUTER JOIN everything...
"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
September 21, 2022 at 5:25 am
To a degree, the difference between ON & WHERE, can be, but isn't entirely, syntactic sugar. However, what I say is, for clarity sake, put filter criteria in the WHERE...
"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
September 20, 2022 at 3:46 pm
Ed has beat me to it.
"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
September 20, 2022 at 2:35 pm
Viewing 15 posts - 766 through 780 (of 22,219 total)