Viewing 15 posts - 2,881 through 2,895 (of 22,227 total)
Let's start with this:
Both are evil!
That out of the way, you can only use NOLOCK by modifying code. You can use READ UNCOMITTED by changing...
"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 15, 2018 at 6:45 am
Oh. My.
I will not be participating in that conversation. Neither as Grant nor as the PASS President. Woof! Y'all have fun.
"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 2:14 pm
Ah, tracked down a copy of the reports possible in the HP thing:
Active Connections • Database Status • Filegroup Space Usage • Locks Wait Rate • Microsoft SQL...
"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:19 am
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
Viewing 15 posts - 2,881 through 2,895 (of 22,227 total)