Reputation
Next tag badge:
530/400 score
62/80 answers
Badges
9 87 159
Newest
 Caucus
Impact
~506k people reached

Apr
29
awarded  Steward
Apr
29
reviewed Reject Organize repeating timestamped values in schema
Apr
28
awarded  Enlightened
Apr
28
awarded  Nice Answer
Apr
28
answered SSDT Schema Compare doesn't work while a BULK INSERT is in progress
Apr
28
reviewed Approve Rich text: VARCHAR, TEXT or BLOB in MySQL
Apr
28
comment Select all records, join with table A if join exists, table B if not
@EBrown No worries. Just to be clear: It is only posted as an alternative - I'm not saying it will always perform better or worse than Aaron's. Thanks for the interesting question.
Apr
28
comment Select all records, join with table A if join exists, table B if not
@EBrown Disregard the percentages. They are internal estimates used by the query optimizer to choose between plan alternatives. They never measure actual performance even in a post-execution ('actual') plan. Measure performance directly. If you have changed the schema yes all bets are off. Feel free to post the execution plan somewhere if you would like an analysis. If you have Plan Explorer, you can use the built-in feature to upload it to the Q & A site there
Apr
28
revised high PAGEIOLATCH_SH waits on server
added 144 characters in body; edited title; edited tags
Apr
28
reviewed Reviewed Restoring Postgres fixtures into a different database with different premissions
Apr
28
reviewed Close A design pattern for category features
Apr
28
answered Select all records, join with table A if join exists, table B if not
Apr
28
reviewed Reject and Edit How to script a table?
Apr
28
revised How to script a table?
edited title
Apr
28
reviewed Reviewed What will be the best suited datatype to store a text file in database
Apr
28
reviewed Close How to execute stored procedure in another procedure in oracle
Apr
28
reviewed Close Switching from Oracle database to Ubuntu
Apr
28
reviewed Leave Open What will be the best suited datatype to store a text file in database
Apr
28
awarded  Good Answer
Apr
28
reviewed Leave Open Database design/structure for address details