713 reputation
1725
bio website twitter.com/#!/BenBrocka
location Iowa
age 24
visits member for 2 years, 7 months
seen Dec 13 '13 at 19:50

I'm a moderator on User Experience Stack Exchange.

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


Aug
30
accepted How can I change the target server type for a trace template?
Aug
29
comment How can I change the target server type for a trace template?
@MaxVernon already tried, it's a binary
Aug
29
comment How can I change the target server type for a trace template?
This is technically about the SSMS feature called "SQL Server Profiler" but we don't seem to have an explicit tag for that.
Aug
29
asked How can I change the target server type for a trace template?
Jul
30
comment More than 20 columns in database table MySQL
Tens of columns isn't a big deal, as long as you're not doing some denormalized nonsense. Just follow good practice to make sure you're not SELECTing more data than you need, don't store in columns what should be rows...should be just fine
Jul
3
comment Can MySQL reasonably perform queries on billions of rows?
Facebook on scaling with MySQL
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus
Jun
7
comment Query intermittently fails with “The multi-part identifier could not be bound”
I'm trying to keep it open to multiple rows, eventually I do have some other tables I need to catch data from. As for the 4 part names, I used to be running this via the live server to send to the dev server (the links aren't on the dev server). Must have forgot I don't need them anymore
Jun
7
revised Query intermittently fails with “The multi-part identifier could not be bound”
added 161 characters in body
Jun
7
comment Query intermittently fails with “The multi-part identifier could not be bound”
@JNK The result's always going to technically be a Cartesian, but it's always one row to one row due to the database design. It's more of a config file than a table...
Jun
7
asked Query intermittently fails with “The multi-part identifier could not be bound”
Jun
7
comment Tools for Identifying Needed Indexes
Is there a query/table you're having poor performance on? As JNK implied you should really only add indexes when you know what you're doing (and test it regardless). Unless you have reason to believe a table needs an index (huge table, slow queries, an obvious clustered index) you shouldn't just try and add them
Jun
1
comment What is a database?
@Shark "in a computer" is how the term is used, generally. Hence "generally" in the entry.
Jun
1
revised What is a database?
clarified body and title
Jun
1
suggested suggested 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!