Aaron Bertrand

Rhode Island

Age: 39

Senior Consultant at SQL Sentry, SQL Server MVP, blogger at sqlperformance.com and sqlblog.com, Mac user, volleyball player, curler, hockey/football/tennis fan, proud father and Canadian, eh?

top accounts reputation activity favorites subscriptions

Make first draft of a new answer part of the permanent revision history

feature-request status-declined editing attribution grace-period asked Jun 28 '12 at 14:50

meta.stackoverflow.com

43 votes

Lock a post for editing, or at least display a warning

feature-request editing asked Jul 26 '12 at 19:15

meta.stackoverflow.com

25 votes

A way to tell if I deleted my comment, it was flagged, or a moderator deleted it?

feature-request comments deleted-comments asked Aug 30 '12 at 16:13

meta.stackoverflow.com

22 votes

What to do when you encounter vengeful users?

discussion comments offensive asked Sep 12 '12 at 22:04

meta.stackoverflow.com

22 votes

Add a visual cue to “votes cast” tab to indicate modification

feature-request voting down-votes asked May 13 at 14:33

meta.stackoverflow.com

20 votes

Please provide a language pick-list for syntax highlighting

feature-request syntax-highlighting asked Jul 18 '12 at 21:43

meta.stackoverflow.com

18 votes

0 new answer to this question

bug status-completed live-refresh asked Aug 16 '12 at 19:08

meta.stackoverflow.com

16 votes

Should the network use thousands separators in numbers?

discussion user-interface display localization numbers asked Sep 23 '12 at 18:50

meta.stackoverflow.com

16 votes

Can we expose class for badges in Data Explorer?

feature-request badges data-explorer schema asked Sep 24 '12 at 13:27

meta.stackoverflow.com

14 votes

Please use proper HTML/CSS to size ads on right margin

bug asked Apr 30 '12 at 14:03

meta.stackoverflow.com

Top Answers

182

Update a table using JOIN in SQL Server?

stackoverflow.com

Why shouldn't we allow NULLs?

dba.stackexchange.com

Comparing DateTime structs to find free slots

stackoverflow.com

SQL Server - inner join when updating

stackoverflow.com

What are Objective Business Reasons to Prefer SQL Server 2012 over 2008 R2?

dba.stackexchange.com

How can a question banned user fix their questions if they're deleted?

meta.stackoverflow.com

Move SQL Server 2008 database files to a new folder location

stackoverflow.com

Does SQL Server read all of a COALESCE function even if the first argument is not NULL?

dba.stackexchange.com

Running total with count?

dba.stackexchange.com

What is the difference between a “record” and a “row” in SQL Server?

dba.stackexchange.com

Get first day of week in SQL Server

stackoverflow.com

In SQL Server, what is the purpose of grouping stored procedures?

dba.stackexchange.com

Proposed change to downvote calculations for fairness by intent

meta.stackoverflow.com

Which DBMS are fast enough for an online game (few thousand players)?

dba.stackexchange.com

Still wrong to start the name of a user stored procedure with sp_?

dba.stackexchange.com

How do I get date/time information from a TIMESTAMP column?

stackoverflow.com

If you really want to reduce the snark level

meta.stackoverflow.com

Retrieve column definition for stored procedure result set

stackoverflow.com

In what data type should I store an email address in database?

dba.stackexchange.com

The reCAPTCHA has become too difficult for humans to solve

meta.stackoverflow.com

Does SQL Sentry Plan Explorer work?

dba.stackexchange.com

Composing the “ultimate database maintenance script”

dba.stackexchange.com

Why does ALTER COLUMN to NOT NULL cause massive log file growth?

dba.stackexchange.com

Why was this question closed as “not a real question”?

meta.stackoverflow.com

Why was my account deleted?

meta.stackoverflow.com

Help us figure out a way to handle the explosion of comments on Stack Overflow

meta.stackoverflow.com

What database technologies do big search engines use?

dba.stackexchange.com

Why is the SELECT clause listed first?

dba.stackexchange.com

Why do wildcards in GROUP BY statements not work?

dba.stackexchange.com

Why does ORDER BY not belong in a View?

dba.stackexchange.com