Reputation
Next tag badge:
563/400 score
69/80 answers
Badges
9 92 162
Newest
 Nice Answer
Impact
~547k people reached

2h
reviewed Reject update tag wiki
2h
reviewed Leave Closed MONTHLY DATE FORMAT in Nateeza
2h
reviewed Leave Closed Database design: balance
3h
reviewed Edit Database design: balance
3h
revised Database design: balance
Improved suggested edit by removing sign-off
3h
reviewed Approve MONTHLY DATE FORMAT in Nateeza
3h
comment Execution plan has TOP operator for query without TOP or ORDER BY
In fact the Top is not because the anti-semi join 'short-circuits' (it does that anyway, without a visible top). See my answer here dba.stackexchange.com/a/18746/1192
4h
reviewed No Action Needed How to keep the sync active with Bucardo
4h
answered Routing data from one SQL Server to another
4h
comment Routing data from one SQL Server to another
You should probably note that the "xml" method will fail for tables with e.g. a geometry/geography type. It may also fail when cast from nvarchar(max) to xml due to invalid characters.
4h
comment Using sp_getapplock to implement a queue. Is it correct? Is there a better way?
@VladimirBaranov I added the link to my answer - it doesn't really belong in a comment, thanks.
4h
revised Using sp_getapplock to implement a queue. Is it correct? Is there a better way?
added 288 characters in body
5h
answered Using sp_getapplock to implement a queue. Is it correct? Is there a better way?
5h
comment SQL Server 2012 window function
Code-only answers can be OK, but you're more likely to attract up-votes from the community if the answer includes some explanation and analysis. Such answers are more likely to benefit future visitors.
5h
revised GROUP BY uninterrupted sequence of logs for same location
Incorporated comment
5h
reviewed Close Database design: balance
6h
revised NOLOCK hint changes order of records returned
Clarified some points, added links
6h
reviewed Approve NOLOCK hint changes order of records returned
6h
revised Should I mark a composite index as unique if it contains the primary key?
added 1018 characters in body
6h
answered Should I mark a composite index as unique if it contains the primary key?