Reputation
2,534
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
9 28
Newest
 Enlightened
Impact
~107k people reached

Jul
28
reviewed No Action Needed Lock wait timeout exceeded; try restarting transaction in NDB
Jul
28
awarded  Caucus
Jul
28
revised How to improve perfomance or Query Execution Time in MySQL?
added 3 characters in body
Jul
28
answered How to improve perfomance or Query Execution Time in MySQL?
Jul
28
revised Why is it bad practice to install SQL Server to the root of a drive
corrected spelling and punctuation, replaced an irrelevant tag
Jul
27
comment Drop and Create Script not working
@MandM: You can have warnings and other nice things when you are doing this through a graphical user interface by clicking buttons, checkboxes etc. The tool that implements that interface typically does the necessary checking for you under the cover, shows you the warnings and asks for confirmation. The engine itself is not designed to have that level of interactivity. You just run a command and it either succeeds or fails.
Jul
27
awarded  Custodian
Jul
27
reviewed Edit MySQL Workbench cloud alternatives
Jul
27
revised MySQL Workbench cloud alternatives
grammar
Jul
27
comment Query to store the current date and time in a specific time range
It's unclear what you are asking. What specifically should the query do?
Jul
27
revised Query to store the current date and time in a specific time range
added 207 characters in body; edited title
Jul
26
answered How to JOIN each row ON NOT IN ( SELECT … )?
Jul
25
revised SQL redundant databases both sets being modified independently yet staying concurrent
edited tags
Jul
24
awarded  Enlightened
Jul
24
comment Best way to write SQL Query that checks a column for non-NULL value or NULL
Thanks for the edit, @PaulWhite!
Jul
24
awarded  sql
Jul
23
revised Cannot connect to SQL Server database regardless of connection string
formatting, typo
Jul
23
comment Best way to write SQL Query that checks a column for non-NULL value or NULL
@MisterMagoo: Thanks. I remember seeing this technique in Paul White's answers, I just didn't bother looking for them. Happily, I've also been reminded that he has dedicated a blog article specifically to this method. Please see my update.
Jul
23
revised Best way to write SQL Query that checks a column for non-NULL value or NULL
added a reference
Jul
23
awarded  Nice Answer