Viewing 15 posts - 2,881 through 2,895 (of 22,219 total)
"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
November 2, 2018 at 4:11 am
1) Yes.
2) Not really. Rebuilding indexes, probably something you'd want to do after data loads, will defragment the data storage internally, moving everything to one area of the file....
"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
November 1, 2018 at 10:15 am
It's extremely situational. It depends on your region of the world, the services you offer, your level of experience, your level of reputation, and finally, whatever the market will bear....
"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
November 1, 2018 at 5:36 am
"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
November 1, 2018 at 5:30 am
Please don't cross post questions. It makes the conversation difficult to keep track of.
I posted one answer over here. Please, anyone else, continue the conversation there.
"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
November 1, 2018 at 5:21 am
1) No. It doesn't work like that. The only issue possible is if, let's say, you created a giant table, then added data to other tables, and then deleted 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
November 1, 2018 at 5:15 am
I think what you're going for is best satisfied by using UNION ALL (bit of a guess). The key is that each of the two SELECT statements have...
"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
November 1, 2018 at 5:06 am
"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
October 31, 2018 at 2:36 pm
"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
October 25, 2018 at 2:25 am
Strong recommendation, turn on query store on the databases you migrate from pre-2014 servers to post-2014 servers (2016 or greater). Leave the database in the old compatibility mode for 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
October 25, 2018 at 1:43 am
First up, check the connecting settings between your SSMS and the clients calling the procedure. There may be differences. Also look at the execution plans to see if they are...
"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
October 25, 2018 at 1:38 am
Ah, if you're already using Azure storage, then it clearly is all a Microsoft issue. Wonder if this counts as a noisy neighbor situation?
"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
October 23, 2018 at 6:58 am
Two things, migrate the BACPAC file to Azure storage first, then import it to the database. Also, make sure you're using an adequate service tier for the imports. It does...
"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
October 23, 2018 at 6:37 am
It's a somewhat tough subject to address. I'd say, make sure, just like any index, that the statistics are up to date. That's more important than anything else.
"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
October 22, 2018 at 12:31 pm
I believe you've identified the crux of my dilemma. 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
October 22, 2018 at 12:22 pm
Viewing 15 posts - 2,881 through 2,895 (of 22,219 total)