Viewing 15 posts - 1,261 through 1,275 (of 22,224 total)
The query doesn't have any kind of filtering through a WHERE clause? It's likely that running the query forces SQL SErver to move all the data in question through memory,...
"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
July 29, 2021 at 11:53 am
Sounds like a parallelism deadlock. They're generally rare, but absolutely do happen. Usually, but not always, there are tuning opportunities that can make them go away; changes to the code,...
"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
July 29, 2021 at 11:49 am
OK then.
My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to true...
"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
July 28, 2021 at 3:03 pm
I am going to rewrite my query performance tuning book. It's a little out of date now. Pretty sure vNext is coming soon(ish). So yeah. I'm supposed to be working...
"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
July 28, 2021 at 12:29 pm
Hi all,
Fun enough, this thread 😉 Mixing state moves with unrelated thoughts about the need to document pgms code (how deep ? how far ?)
As a frog, I’ve learned...
"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
July 28, 2021 at 11:57 am
Unfortunately, that actually proves that they don't know. Bob Ward is still talking about the use of reorganize for index...
"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
July 28, 2021 at 11:51 am
OK then.
My recent experience with "flat-earthers" taught me that it's almost useless trying to prove anything to true believers. For...
"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
July 28, 2021 at 11:44 am
Do you again think I’m wrong on it?
Yes.
"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
July 27, 2021 at 11:11 am
Changing them just means using different percentages to determine when to perform reorganize vs rebuild. The problem isn't the percentage - the problem is when to choose a reorganize. ...
"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
July 26, 2021 at 6:47 pm
Too bad you couldn't get a bit further south to Texas - which has no state income tax 🙂
The real question you need to answer is, are you 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
July 26, 2021 at 3:55 pm
Ola's stuff works on the 5/30 methodology for index maintenance. The maintenance plan rebuild task uses the 5/30 methodology - the code the article links to (Adaptive Index Defrag)...
"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
July 26, 2021 at 3:50 pm
I don't have a test instance for Managed Instance to look at for you. Maybe open a ticket with support. I'd think you'd be able to see more data 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
July 26, 2021 at 1:23 pm
Filestream just isn't supported on Azure SQL Database or Managed Instance. You just can't use it at all. I haven't tested this particular scenario with the Migration Service, but...
"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
July 26, 2021 at 12:57 pm
So, if you're after some increased efficiency and reduced overall load on SQL servers the last people you should be listening to are Microsoft employees.
That's a pretty tough accusation....
"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
July 26, 2021 at 12:45 pm
Grant, I do have a question for you. In the past I've applied for jobs out of state. During the application process there was often a question that read...
"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
July 26, 2021 at 12:25 pm
Viewing 15 posts - 1,261 through 1,275 (of 22,224 total)