738 reputation
11127
bio website twitter.com/#!/BenBrocka
location Iowa
age 24
visits member for 3 years, 3 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.


Jun
1
revised What is a database?
clarified body and title
Jun
1
suggested approved edit on What is a database?
Jun
1
comment What is a database?
A miserable little pile of pages. But enough talk; have at you!
May
31
comment sqlcmd slow against SQL Server 2008 R2
I'm not supposed to be using 3.5 million individual one line text files?
May
16
revised Combine column from multiple rows into single row
added 173 characters in body
May
16
comment Combine column from multiple rows into single row
Yep, this works like a charm. @MarlonRibunal SQL Fiddle's really shaping up!
May
16
accepted Combine column from multiple rows into single row
May
15
asked Combine column from multiple rows into single row
May
14
revised Normalization and Breaking down tables for InnoDB
Removed fluff from title
May
14
suggested approved edit on Normalization and Breaking down tables for InnoDB
Apr
26
awarded  Nice Question
Apr
20
comment Identifying rows which don't match a master row
This solution was particularly excellent as I can use a variable as the table name, so I make one change and fetch totally different tables.
Apr
19
revised Identifying rows which don't match a master row
edited title
Apr
19
accepted Identifying rows which don't match a master row
Apr
18
comment Identifying rows which don't match a master row
@AaronBertrand nvarchars and ints, with some odds and ends like datetimes. Could be anything, multiple tables actually.
Apr
18
comment Identifying rows which don't match a master row
Impressive, I would have never even thought to do this. Toying with this now
Apr
18
comment Identifying rows which don't match a master row
I'm only looking to query these servers and update 4 times a day right now so it shouldn't be a big deal. Querying 40 servers, half with Ping > 2000ms CPU/I/O speed is never the bottleneck...
Apr
18
comment Identifying rows which don't match a master row
Hm never used hash before, that sounds perfect. I'll see if I can make it work
Apr
18
revised Identifying rows which don't match a master row
added 259 characters in body
Apr
18
revised Identifying rows which don't match a master row
added 504 characters in body