Viewing 15 posts - 7,066 through 7,080 (of 22,226 total)
Excellent point. Not something I tend to think of since I try so hard to avoid hints.
"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
December 16, 2014 at 11:44 am
jvila (12/16/2014)
[font="Courier New"]
Name |Writes | Reads | Columns | IncludedColumns
-------------------------------------------------------------------------------
INDEX A| 15.112|2.117| BB,AA with included columns CC,EE
INDEX B|...
"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
December 16, 2014 at 9:12 am
New Born DBA (12/16/2014)
Grant Fritchey (12/10/2014)
"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
December 16, 2014 at 9:02 am
Jeff Moden (12/16/2014)
"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
December 16, 2014 at 8:24 am
Yeah, a big part of why it's so important to pick the correct location for the clustered index is because it's so difficult later to rebuild them, especially if they're...
"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
December 16, 2014 at 8:23 am
Tac11 (12/16/2014)
you said in previous reply 'They don't do the same thing' (VERIFYONLY AND CHECKSUM).
In your article you said 'Verifyonly: Another way you can ensure that your...
"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
December 16, 2014 at 7:06 am
In a perfect world, you would not store NULL values. However, in the world we live in, it's pretty normal to store NULL.
The real issue comes down to design and...
"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
December 16, 2014 at 5:07 am
Just to know what they are.
The primary key uniquely identifies a row.
A foreign key is used to relate one table to another. It uses the primary key (or...
"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
December 16, 2014 at 5:03 am
Yep. A long operation. Because clustered is not simply a property of the PK, it describes the type of index being created. A clustered index defines how the data is...
"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
December 16, 2014 at 4:57 am
Both. And more.
CHECKSUM validates that what was read from the disk is what got written to your backup file. VERIFY_ONLY will then validate that what was written to your backup...
"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
December 16, 2014 at 4:54 am
Another vote for source control. That's the single best approach.
You could look to third party tools. For example, Red Gate Software (my employer) has a tool called SQL Compare [/url]that...
"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
December 16, 2014 at 4:50 am
Koen Verbeeck (12/16/2014)
The tribal award finalists are out and a lot of threadizens are nominated in very different categories!
Somehow my blog ended up in the category "Best Blog",...
"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
December 16, 2014 at 4:47 am
Not a problem. Glad to help. And thanks for posting the solution back here. Now anyone with a similar issue that finds this thread on a search will know how...
"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
December 16, 2014 at 4:41 am
patrickmcginnis59 10839 (12/15/2014)
Grant Fritchey (12/15/2014)
patrickmcginnis59 10839 (12/15/2014)
Grant Fritchey (12/15/2014)
So, use...
"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
December 15, 2014 at 8:31 pm
pottapitot (12/15/2014)
"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
December 15, 2014 at 7:28 am
Viewing 15 posts - 7,066 through 7,080 (of 22,226 total)