Viewing 15 posts - 1,816 through 1,830 (of 22,219 total)
If you need to join multiple values to multiple values, the better approach is what's called an interim table. .
I don't think 'interim table' is the correct term...
"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
May 19, 2020 at 12:56 pm
Did I misread your compatibility mode? If so, my bad, apologies. Yes, you can have the new compatibility mode enabled and then disable the new cardinality estimator.
As to the rest,...
"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
May 19, 2020 at 11:52 am
I could try to guess at what you're going for, but instead, could you put the table names in with the tables. Show some of the relationships, primary & foreign...
"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
May 19, 2020 at 10:28 am
If you have tables with fewer than 200 rows, the statistics won't be changing very often unless you're doing lots of replacements of that data, so I don't see how...
"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
May 19, 2020 at 10:22 am
Development is where development and testing occurs. No production information should be stored there. You certainly shouldn't have weird cross server queries from production to development. This is a fundamentally...
"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
May 18, 2020 at 5:27 pm
I don't see anything in what you posted to suggest that it's a cache problem. If you have two instances on the server, make sure each one has a max...
"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
May 18, 2020 at 5:24 pm
See Grant. I was paying attention! <g>
Never a doubt in mind!
Ha!
"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
May 14, 2020 at 5:40 pm
WHOOP!
All those classes on how to use Extended Events haven't been wasted.
And before there's more whinging about XML in Extended Events, let me point out two things. Using the Live...
"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
May 14, 2020 at 12:42 pm
Not a problem. This is the kind of stuff people really need right now. I hope it helps.
"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
May 11, 2020 at 2:18 pm
I'd be buying radio gear, but Mrs. Scary has me cut off.
"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
May 10, 2020 at 5:06 pm
I'm not sure what you mean, DLL references. You'll have to clarify.
Can you query an Azure SQL Database and output the results to a local file like Excel? Yes. Pretty...
"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
May 8, 2020 at 12:32 pm
Yeah, you have to save them as XML and then they can upload.
Index hints are EXTREMELY hit or miss and mostly miss. The plan will show the index being used,...
"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
May 7, 2020 at 7:16 pm
Just getting the Execution Plan should be enough. Getting the Plan Plus Runtime Metrics won't add much to your information. Use the "Estimated Plan" button and that will give you...
"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
May 7, 2020 at 1:57 pm
Have you looked at the plans yet to see what the differences in row estimates and behavior are?
I read through the update notes. I didn't spot anything that looks...
"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
May 7, 2020 at 1:12 pm
So it is a parameter & not a local variable?
Hmmm.... What about making it a local variable. Instead of doing the calculation on the date value there, do it on...
"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
May 7, 2020 at 12:55 pm
Viewing 15 posts - 1,816 through 1,830 (of 22,219 total)