Viewing 15 posts - 1,261 through 1,275 (of 22,219 total)
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
Thanks for the support on the move. A couple of notes. First, I'm not changing jobs. I love Redgate and you'll have to pry this job from my dead cold...
"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:19 pm
Going backwards is hard. There are no shortcuts. The best way is going to be to script everything out and then build data migration processes using whatever tools you're most...
"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 23, 2021 at 10:33 am
Quick note regarding any 3rd party solution:
I'm game to use any of them. Show me a restore to a point in time that meets our SLA, RTO & RPO. Now...
"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 21, 2021 at 1:28 pm
Months of log restores? Oh no. That will be a nightmare, regardless of the failover question. Speaking of, because the secondary has the same transaction id values and will be...
"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 21, 2021 at 11:40 am
Rebuilding an index updates the statistics. After updating statistics, new execution plans get created. Sounds like the stats update may have lead to a different plan with poor performance. Since...
"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 20, 2021 at 11:32 am
Viewing 15 posts - 1,261 through 1,275 (of 22,219 total)