Viewing 15 posts - 1,816 through 1,830 (of 22,224 total)
As you've defined it, a simple UNION query will get you what you want.
SELECT a.id_a as Id_Obj,
a.customer_a as Customer,
a.Name_a as Name
FROM dbo.db_a as a
UNION
SELECT b.id_b as Id_Obj,
b.customer_b...
"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 20, 2020 at 5:41 pm
So, you're not looking for tuning then, just management?
What about index compression? That's a huge win for some people, depending on your data. Also, columnstore indexes may, emphasize that word,...
"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 20, 2020 at 2:11 pm
I have no clue how to remove the attachments. Edit doesn't work, I can change only text.
I have admin access, so I went ahead and removed them for you.
Try...
"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 5:35 pm
If you want to, get a copy of SentryOne Plan Explorer. It's free. It has a way to anonymize the plans. Post those and no code will be visible.
"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 3:45 pm
Two things. First, the query is in the plan. I sure don't see anything that's even remotely proprietary, but if there's a concern, you should remove those from the post.
Second,...
"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 3:45 pm
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
Viewing 15 posts - 1,816 through 1,830 (of 22,224 total)