246 reputation
29
bio website aruplab.com
location United States
age 38
visits member for 2 years, 2 months
seen Jan 31 at 22:14

I am a software engineer from Salt Lake City, Utah.

enter image description here


Jan
17
comment Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Thanks! I had a few indexes missing from my table. When I added all 3 the delete went from 57 seconds to less than a second!
Jan
17
comment Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
@AaronBertrand - OK, thanks!
Jan
17
accepted Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Jan
17
comment Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Wow, really? I have been told to use those quite a lot when performance tuning...
Jan
17
revised Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
added 224 characters in body
Jan
17
awarded  Custodian
Jan
17
reviewed Approve suggested edit on Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Jan
17
asked Why is SQL Server using a clustered index scan for a self referencing FK cascade delete
Sep
4
awarded  Notable Question
Aug
30
comment Is polling the only way for updating app's data from a database?
-1 Service Broker does not seem have anything built into it to let an app know that it has received a message. (I am currently stuck on this issue.)
Aug
16
comment Permission required to view a database diagram
I have to say, I think it is crazy that only DBO users can see the diagrams. There are so many permissions in SQL Server, they really could not make some way to set permissions on diagrams?
Aug
9
revised Replication fails because of a non-existent foreign key
added 303 characters in body
Aug
9
comment Replication fails because of a non-existent foreign key
@AaronBertrand - Alas, both of those return 0 rows. The FK is well and truely gone... I don't get why replication is complaining. (I have also tried deleting and recreating both publisher and subscriber).
Aug
9
revised Replication fails because of a non-existent foreign key
added 86 characters in body
Aug
9
asked Replication fails because of a non-existent foreign key
Jul
25
comment Foreign Key off of a UNIONed View
@ypercube - They don't have the same structure. Just a few overlapping columns shown here.
Jul
25
asked Foreign Key off of a UNIONed View
May
10
accepted Merge Statement + Replication difference for SQL Server 2012
May
10
comment Merge Statement + Replication difference for SQL Server 2012
@Kin - I think that is it. If you post as answer I will accept.
May
9
comment Merge Statement + Replication difference for SQL Server 2012
@Kin - The merge statement does have the PK in it. (I did not realize that.) The PK is an enterprise wide value and should never change... But something odd is happening, so maybe it is changing somehow.