23,313 reputation
33981
bio website blogs.msdn.com/b/sql_pfe_blog
location In the Ocean somewhere...
age
visits member for 3 years, 1 month
seen 4 mins ago

SQL Server Premier Field Engineer at Microsoft.

Twitter: @SQLife
Blog: http://blogs.msdn.com/b/sql_pfe_blog/
Email: sqlsalt [at] outlook [dot] com

Disclaimer
The views expressed on my posts on this site are mine alone and do not reflect the views of my company. All posts of mine are provided "AS IS" with no warranties, and confers no rights.

The following disclaimer applies to all code, scripts and demos available on my posts:

This Sample Code is provided for the purpose of illustration only and is not intended to be used in a production environment. THIS SAMPLE CODE AND ANY RELATED INFORMATION ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A PARTICULAR PURPOSE. We grant You a nonexclusive, royalty-free right to use and modify the Sample Code and to reproduce and distribute the object code form of the Sample Code, provided that You agree: (i) to not use Our name, logo, or trademarks to market Your software product in which the Sample Code is embedded; (ii) to include a valid copyright notice on Your software product in which the Sample Code is embedded; and (iii) to indemnify, hold harmless, and defend Us and Our suppliers from and against any claims or lawsuits, including attorneys’ fees, that arise or result from the use or distribution of the Sample Code.


Dec
7
revised Determining if indexes are redundant
added 28 characters in body
Dec
7
revised Determining if indexes are redundant
added 1307 characters in body
Dec
7
answered Determining if indexes are redundant
Dec
7
comment Determining if indexes are redundant
So when the primary key constraint was specified it was explicitly set as a nonclustered index? The reason I ask is, because by default a primary key constraint creates a clustered index provided there isn't one on the table already and unless otherwise specified.
Dec
7
comment Determining if indexes are redundant
Are Index1, Index2, and Index3 nonclustered indexes? Is this table a clustered index with it on Id?
Dec
7
comment How to Audit for Access with Cross Database Ownership Chaining
Are you just looking to find out which databases and/or instances have this set?
Dec
7
comment Can't grant role permissions under sysadmin login
Are you SURE you in the right database context? Do a select against the principals catalog view just to verify.
Dec
6
comment Appending backups while overwriting expired sets
@MrVimes The point I'm trying to get across is by all means do take the word of the experts here, but for reliability a test is always the best. But....the professionals here will be able to help get you their experience.
Dec
6
awarded  Enlightened
Dec
6
comment Appending backups while overwriting expired sets
@MrVimes Not saying that at all. By all means get input from us here, but I'd recommend testing out and seeing with your own eyes whatever answer you get. A fact is something you can prove. Just my $0.02.
Dec
6
comment Appending backups while overwriting expired sets
@MrVimes :-) "Reliable" = testing it out and having proof.
Dec
6
revised SQL Server Index vs Statistic
added 4 characters in body
Dec
6
revised What are SQL Server Securables?
deleted 1 characters in body
Dec
6
awarded  Nice Answer
Dec
5
revised What are SQL Server Securables?
added 566 characters in body
Dec
5
revised What are SQL Server Securables?
added 566 characters in body
Dec
5
revised What are SQL Server Securables?
edited tags
Dec
5
answered What are SQL Server Securables?
Dec
5
revised SQL Server Index vs Statistic
added 706 characters in body
Dec
5
revised SQL Server Index vs Statistic
added 270 characters in body