728 reputation
11127
bio website twitter.com/#!/BenBrocka
location Iowa
age 24
visits member for 3 years, 2 months
seen Aug 21 at 21:19

I'm a moderator on User Experience Stack Exchange. (That's right here!)

Programmer/Systems Analyst working mostly in PHP/HTML/CSS. Enthusiast follower of User Experience topics and solutions.


Sep
17
awarded  Teacher
Sep
17
answered What is the consensus on using NOT NULL constraints on all text-based fields in a table?
Sep
16
awarded  Commentator
Sep
16
comment Recent Queries in SQL Server 2005
thanks, messing with that now
Sep
16
comment Recent Queries in SQL Server 2005
Helpful but is there any way to get more than one statement from this? Unfortunately the operation I'm analyzing is a large series.
Sep
16
comment Recent Queries in SQL Server 2005
Perfect, catches a bit more info than I need but I'm tinkering with the filters.
Sep
16
accepted Recent Queries in SQL Server 2005
Sep
16
asked Recent Queries in SQL Server 2005
Sep
14
revised Why is SSMS inserting new rows at the top of a table not the bottom?
added 32 characters in body
Sep
14
comment Why is SSMS inserting new rows at the top of a table not the bottom?
It's Management studio 2008, the server is 2005, should have been clearer. I didn't know there was an "open table" command, I've always used the select statments
Sep
14
comment Why is SSMS inserting new rows at the top of a table not the bottom?
I wasn't planning on depending on the order, but visually it is a bit annoying that my last inserted items are suddenly at the top.
Sep
14
awarded  Editor
Sep
14
accepted Why is SSMS inserting new rows at the top of a table not the bottom?
Sep
14
revised Why is SSMS inserting new rows at the top of a table not the bottom?
Changed title to be more accurate
Sep
14
comment Why is SSMS inserting new rows at the top of a table not the bottom?
Good to know. I knew this was a hint to change the app to use order by (it's an inherited app with a great deal of bad practice) but I was wondering exactly why it happened.
Sep
14
asked Why is SSMS inserting new rows at the top of a table not the bottom?
Sep
10
comment Is there a reason to use extremely abbreviated table names?
Since the tables don't provide any non-automatic metadata I'm not sure that's a valid argument...
Sep
10
comment Is there a reason to use extremely abbreviated table names?
Part of the problem is that these tables are not being maintained by accountants, they're being maintained by a systems analyst and generally our IT Dept. aptrx is actually one of the most logical names I've found, one of the only ones I've remembered. Also note that there are several hundred tables; the basic abbreviations like "ap" for "accounts payable" are very easy to learn, the literally 100 suffixes after "ap" are not...
Sep
10
awarded  Scholar
Sep
10
accepted Is there a reason to use extremely abbreviated table names?