Viewing 15 posts - 4,381 through 4,395 (of 22,219 total)
psred (9/27/2016)
"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
September 27, 2016 at 1:57 pm
psred (9/27/2016)
"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
September 27, 2016 at 1:55 pm
shanegair (9/27/2016)
Sorry I am not relaying clear information. I want all records with UOM_Control = 'S' and only UOM = 'LBS' where UOM_control = 'C'
Then logically, you have an...
"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
September 27, 2016 at 10:15 am
If you're getting wildly different plans between servers, there has to be differences. The differences can be in the statistics on the data in the database. The differences can 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
September 27, 2016 at 10:13 am
Rich Mechaber (9/27/2016)
"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
September 27, 2016 at 8:33 am
Yeah, Columnstore is a good thing is you're doing lots of aggregates in the reports. If we're doing point lookups & just general data retrieval though, it falls down badly....
"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
September 27, 2016 at 8:28 am
Also, what is the Recovery Point Objective, the amount of data that the company is willing to lose during the log shipping operation. The answer is always zero, but zero...
"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
September 27, 2016 at 7:58 am
The same general rules are going to apply to this as they would to any other set of indexes. You're talking about having 1-16 different criteria for searching the table....
"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
September 27, 2016 at 7:56 am
Phil Parkin (9/27/2016)
"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
September 27, 2016 at 6:05 am
Ed Wagner (9/26/2016)
Exactly my point, but the chair is unnecessary. The image of you with the bat comes to mind. 😛
They won't let me bring the bat to work...
"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
September 26, 2016 at 8:36 am
Brandie Tarvin (9/26/2016)
HELLO! This is my new "must have".
Shared it on Twitter. I think a few people may have hurt themselves attempting to order one.
"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
September 26, 2016 at 8:27 am
Ed Wagner (9/26/2016)
"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
September 26, 2016 at 8:17 am
xsevensinzx (9/26/2016)
Grant Fritchey (9/26/2016)
"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
September 26, 2016 at 8:09 am
dmbaker (9/26/2016)
Grant Fritchey (9/26/2016)
"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
September 26, 2016 at 7:38 am
kiwood (9/26/2016)
But let me play a little devil's...
"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
September 26, 2016 at 6:48 am
Viewing 15 posts - 4,381 through 4,395 (of 22,219 total)