4,026 reputation
11123
bio website sqlblog.com/blogs/…
location Chicago, IL
age
visits member for 2 years, 4 months
seen 2 hours ago

Developer


Feb
5
answered Hierarchical structure with limited number of records per user
Jan
27
asked Can we tell dbcc to ignore subnormal real values?
Dec
30
asked Does this query always correctly retrieve the types of array parameters
Nov
12
answered Can PostgreSQL support integration test with some kind of throwaway overlay?
Nov
8
asked Are there other ways to select a dynamic list of columns?
Nov
7
asked How can I keep a result set without keeping the transaction open?
Sep
25
answered What are the advantages of having a centralised SQL database server for development?
Sep
25
answered Storing revisions in SQL Server (simply much like TFS)
Jun
4
answered Can I add a unique constraint that ignores existing violations?
Apr
4
answered Gaps and islands: client solution vs T-SQL query
Apr
4
asked Gaps and islands: client solution vs T-SQL query
Mar
18
answered Issue with ROW_NUMBER and DISTINCT
Mar
15
answered Handling concurrent access to a key table without deadlocks in SQL Server
Mar
3
answered Inserting and updating and selecting at thousands of times per second
Feb
12
answered Indexing strategy when using the between operator SQL Server 2008
Feb
11
answered Symmetric self-referential many-to-many
Feb
7
answered SQL Server 2008 and extended properties
Feb
1
answered SQL Server Select Count READ_COMMITTED_SNAPSHOT QUESTION
Jan
30
answered Relationship that are optionally more specific
Jan
29
answered Is it OK to keep a value which updates in a table?