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
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
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.
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
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
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
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
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
comment Combine column from multiple rows into single row
Yep, this works like a charm. @MarlonRibunal SQL Fiddle's really shaping up!
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
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
Mar
7
comment Splitting Tables in MySQL. Good practice?
That sounds...horrifying.
Mar
1
comment Adding columns to production tables
Did you mean "doesn't" require adding data to the rows in your second line?
Feb
27
comment Speed up INSERTs
Your bottlenecks on the laptop are probably very different (and variable!) compared to a proper server. If you're going to stress test at least run it on a device set up as a server with nothing else running. You're likely to hit RAM/CPU bottlenecks on a laptop that might not exist on a production machine