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.


Oct
24
awarded  Popular Question
Sep
13
awarded  Popular Question
Sep
9
awarded  Yearling
Aug
30
revised How can I change the target server type for a trace template?
added 49 characters in body
Aug
30
revised How can I change the target server type for a trace template?
added 141 characters in body
Aug
30
comment How can I change the target server type for a trace template?
Okay, that does work. Important to note that when you pick the different server type, the template name disappears (it re-filters the templates to show you the selected server type's templates), but if you save it does edit the selected template. Disorienting, but now I know.
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.