Viewing 15 posts - 2,881 through 2,895 (of 22,224 total)
I've never seen HP OMI SQL Server Management Pack in action. I went to the HP documentation, but the page won't load, so I can't comment on any...
"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 14, 2018 at 11:07 am
DECLARE is for creating local variables. These are different from parameters. Both start with @, but are treated differently within the engine, therefore different mechanisms for definition.
"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 12, 2018 at 5:54 am
The trouble is that SET STATISTICS skews things so badly that the differences...
"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 12, 2018 at 5:52 am
Highly appreciated and thank you so much for your explanation and advices.
1) I...
"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:22 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 2, 2018 at 4:14 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 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
Viewing 15 posts - 2,881 through 2,895 (of 22,224 total)