Viewing 15 posts - 4,396 through 4,410 (of 22,227 total)
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
Thanks everyone for the feedback. I was hoping someone would come in and argue in favor of hiding information since it sometimes seems to be considered a valid position.
"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:09 am
call.copse (9/26/2016)
"If you really can't fix the problem then,"Can't fix the problem? Does this situation really occur? Everything is fixable one way or another...
If the issue is beyond someone's capabilities...
"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:08 am
I would suggest setting up an Extended Events blocked process report. Here's a blog post[/url] on how to do it. You can also query sys.dm_exec_requests when the blocking is occurring...
"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 23, 2016 at 12:35 pm
If I can afford a full scan, that's better. Absolutely.
"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 23, 2016 at 10:31 am
Mike Scalise (9/23/2016)
So something like:
1) DBCC CHECKDB
2) Update all...
"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 23, 2016 at 9:01 am
What was it? A startup trigger or something 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
September 22, 2016 at 1:00 pm
Take a look at the SEQUENCE object. That's one way to have this without using IDENTITY. Plus, IDENTITY just using SEQUENCE under the covers anyway.
"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 22, 2016 at 12:59 pm
Viewing 15 posts - 4,396 through 4,410 (of 22,227 total)