762 reputation
1720
bio website
location
age
visits member for 3 years, 7 months
seen Oct 17 at 6:30

Jun
29
comment How does SQL Server choose an index key for a foreign key reference?
I may not be understanding, but if I create primary key on the table as a clustered index in the example above, it will not use the duplicate index key as a reference (and the duplicate can be deleted). This appears to be related to it being a heap first...
Jun
29
asked How does SQL Server choose an index key for a foreign key reference?
Jun
26
comment How to log error details when using using try/catch for dynamic SQL backup commands
You may want to see this: stackoverflow.com/questions/5966670/…
Jun
24
awarded  Commentator
Jun
24
comment How can I check the integrity of disabled foreign key relationships for each individual table? (SQL Server 2008)
Will your tables have primary keys or unique keys that you can use as references for the foreign keys? You won't be able to build these disabled foreign keys (in your example) without them.
Jun
16
awarded  Quorum
Jun
16
revised How to efficiently check EXISTS on multiple columns?
deleted 8 characters in body
Jun
16
answered How to efficiently check EXISTS on multiple columns?
Jun
16
comment How to efficiently check EXISTS on multiple columns?
@Thomas: Welcome to Stack Exchange. Have watched your SQL Bits Extreme DW presentation about twenty times.
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
May
31
accepted What is the purpose of the database 'owner'?
May
31
revised What is the purpose of the database 'owner'?
deleted 1 characters in body
May
31
asked What is the purpose of the database 'owner'?
May
13
answered How to split tables without affecting all stored procedures
May
2
accepted ETL: extraction strategy for 200 source databases
Apr
30
comment ETL: extraction strategy for 200 source databases
Thanks for the detailed answer. Do you have any thoughts on using replication as a low impact means of mirroring the source data?
Apr
30
asked ETL: extraction strategy for 200 source databases
Apr
2
accepted Is there a performance benefit to placing transaction log files on a separate drive?
Mar
30
awarded  Nice Question