Reputation
618
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 8 16
Newest
 Yearling
Impact
~48k people reached

  • 0 posts edited
  • 3 helpful flags
  • 29 votes cast
Jan
25
accepted What is more appropriate sp_updatestats or UPDATE STATISTICS?
Jan
22
awarded  Yearling
Jan
21
comment What is more appropriate sp_updatestats or UPDATE STATISTICS?
@JohnM, silly me! Admit, you sneaked up this link in in the last second! ;)
Jan
21
comment What is more appropriate sp_updatestats or UPDATE STATISTICS?
@JohnM, yep, why?
Jan
21
asked What is more appropriate sp_updatestats or UPDATE STATISTICS?
Jan
13
awarded  Notable Question
Jan
5
accepted Server permissions of an activation stored procedure of a Server Broker queue
Jan
5
accepted Why does fn_my_permissions return empty rowset?
Sep
1
accepted Is REPEATABLE READ the right choice for validation before modifying data?
Sep
1
revised Is REPEATABLE READ the right choice for validation before modifying data?
added 30 characters in body
Sep
1
asked Is REPEATABLE READ the right choice for validation before modifying data?
Sep
1
accepted Is there a performance difference in committing and rolling back a read-only transaction?
Sep
1
comment Is there a performance difference in committing and rolling back a read-only transaction?
@AaronBertrand that's fair enough, thank you.
Sep
1
revised Is there a performance difference in committing and rolling back a read-only transaction?
deleted 10 characters in body
Sep
1
asked Is there a performance difference in committing and rolling back a read-only transaction?
Aug
26
comment zero-or-one to zero-or-one
Thank you for contributing, I've considered that approach too. I decided against it in the end because sequence is awkward to implement in sql2008 and more trouble than I'd willing to put up with.
Aug
24
accepted How to avoid a “duplicate key” error?
Aug
21
revised How to avoid a “duplicate key” error?
edited title
Aug
20
accepted zero-or-one to zero-or-one
Aug
20
comment zero-or-one to zero-or-one
You are right in that I gave a simplified version. Of course both Task and Hazard objects are more complex than described and have a slew of their own unique properties. Thus, having them in one table unfortunately won't work for me, but thank you for the suggestion!