3,627 reputation
1820
bio website sqlblog.com/blogs/…
location Chicago, IL
age
visits member for 1 year, 5 months
seen 3 hours ago
stats profile views 234

Developer


Apr
5
revised Gaps and islands: client solution vs T-SQL query
added 78 characters in body
Apr
4
revised Gaps and islands: client solution vs T-SQL query
added 146 characters in body
Apr
4
revised Gaps and islands: client solution vs T-SQL query
added 132 characters in body
Apr
4
revised Gaps and islands: client solution vs T-SQL query
added 13 characters in body
Mar
17
revised Handling concurrent access to a key table without deadlocks in SQL Server
added 720 characters in body
Mar
15
revised Handling concurrent access to a key table without deadlocks in SQL Server
added 10 characters in body
Mar
6
revised Many to Many and Weak Entities
edited tags
Feb
13
revised How should deletions be handled in the database?
added tag
Feb
11
revised Symmetric self-referential many-to-many
added tag
Feb
10
revised How arrange columns in sp_whoisactive by Adam Machanic
edited body
Feb
9
revised How arrange columns in sp_whoisactive by Adam Machanic
the name is Machanic
Jan
31
revised Is there any tangible difference between a unique clustered index and a clustered primary key?
fixed typo: on - one
Jan
30
revised Relationship that are optionally more specific
edited tags
Jan
24
revised When to create Indexes?
added tag
Jan
17
revised What is the difference between a “record” and a “row” in SQL Server?
edited body
Jan
1
revised Finding violations of the symmetry constraint
added 108 characters in body
Dec
10
revised Replacing composite key with surrogate
edited tags
Nov
29
revised SQL 2008 RTM Temp Tables
edited tags
Nov
27
revised MySQL unique constraint across two columns
added test script
Nov
27
revised MySQL unique constraint across two columns
added 88 characters in body