Viewing 15 posts - 781 through 795 (of 22,227 total)
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
So, you're going for a swim in the deep end of the pool.
Let's start with what you shouldn't do. Don't rebuild the indexes. Probably, they hit issues in the past,...
"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 1:15 pm
Although, if you move that part of the WHERE clause to the ON clause, you should still get an outer join.
"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 12:45 pm
Really hoping they don't mangle the B5 reboot.
From your keyboard to the ears of the gods.
"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 12:16 pm
Absolutely "Babylon 5" was and is the best does not mean I watch any other science fiction fantasy if I can get my hands on it! I happen 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
September 19, 2022 at 10:17 am
Yeah, plan forcing will translate. Automated tuning won't. It will have to "relearn" the automated tuning stuff. Also doesn't survive reboots.
"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 19, 2022 at 8:23 am
Yeah, I know that one. Thanks!
"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 18, 2022 at 12:07 pm
I want more of B5... for work I would like those that don't understand the technology would include and listen to those that do in their discussions.
Oh, I've got...
"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 17, 2022 at 3:07 pm
Viewing 15 posts - 781 through 795 (of 22,227 total)