Viewing 15 posts - 946 through 960 (of 22,227 total)
Glad you got it working.
This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'
That kind of wild card search can't make use 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
March 17, 2022 at 2:02 pm
Congrats, Jeff. Quite an achievement. I used to try and keep ahead, but haven't bothered.
Now I wonder where I get to 1mm first. Here or in miles flown. At...
"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
March 17, 2022 at 1:56 pm
Glad you got it working.
This part of the query is still going to cause problems: WHERE CompleteTaxonText Like '%rupicapra%'
That kind of wild card search can't make use of statistics and...
"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
March 16, 2022 at 8:39 pm
Let's be really clear, SSD are indeed, insanely fast.
If you put everything onto one SSD can you overwhelm it, despite it being insanely fast?
Yes.
There's a reason organizations like Pure Storage...
"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
March 16, 2022 at 1:13 pm
Extremely important thing to remember:
A common table expression (CTE) is not a table. It is an expression. A query. It does not, in any way, represent data storage, temporary or...
"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
March 16, 2022 at 1:08 pm
Well, defining stuff like this as "normal" is probably not the best way to describe it. However, is something like this expected? Yeah.
One of the hardest things is recovery from...
"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
March 16, 2022 at 1:02 pm
I'm not going to try to unpack all of that.
The optimizer thinks that the filter on C_MT_B_COMM_TO_PTY.PARTY_TYP_CD + ':' = 'Contact' + ':' is going to do a lot more...
"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
March 16, 2022 at 12:55 pm
I don't believe the load balancing aspect, at all.
Yes, you can move some queries offline. However, that is not load balancing. Load balancing is the automated process of distributing 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
March 15, 2022 at 1:38 pm
Or get the older version. Forgot to mention that.
"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
March 15, 2022 at 1:10 pm
You sure you got the question right? Looking through that list I can only see one thing that IS a benefit. Replication does not load balance. Replication doesn't distribute queries....
"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
March 15, 2022 at 12:56 pm
I am not a fan of debugging within T-SQL queries, however, if you want to do it, SQL Server Management Studio is free and it does include debugging.
The...
"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
March 15, 2022 at 12:47 pm
It's the code. I know you've said you can't affect that, but that's where the problem is. You have to use the correct data types. That's how you fix these...
"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
March 8, 2022 at 7:23 am
I checked this table it has no FK, or triggers, and character fields are defined as Nvarchar. There are NO indexes or a PK set of this table.
Are 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
March 7, 2022 at 5:42 pm
Yeah, absolutely.
Although, I have good news. There is an open source software that does a lot of this, OpenQueryStore. I saw this when it was an in-house private bit...
"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
March 4, 2022 at 3:10 pm
I appreciate the feedback.
One reason I've used index rebuilds in the past is because some of the third-party apps we rely on can sometimes end up with a query...
"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
March 4, 2022 at 1:59 pm
Viewing 15 posts - 946 through 960 (of 22,227 total)