4,198 reputation
11327
bio website
location Chicago, IL
age
visits member for 2 years, 9 months
seen yesterday

Developer


Aug
13
answered PostgreSQL: Trigger for updating view doesn't work
Jul
25
answered Filling in missing dates in record set from generate_series()
Jul
24
asked Should I shrink my database?
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