713 reputation
1725
bio website twitter.com/#!/BenBrocka
location Iowa
age 23
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.


Jan
11
comment Are there any risks to granting users SQL Server SHOWPLAN permission?
Especially negligable that, given this is a development server, all queries would be from devs and IT people, not users.
Jan
9
comment Are there any risks to granting users SQL Server SHOWPLAN permission?
It's a development server. Your devs should be able to perform the digital equivalent of setting it on fire and throwing it out the window. Not giving them SHOWPLAN is insane.
Jan
9
comment Does ORDER BY on a clustered key effect performance?
In this case I'm grabbing rows for presentation so order matters and I'm usually only JOINING tables which are all clustered on the same primary/foreign key. Is the ORDER BY additional work even when I join two tables clustered in the same exact manner?
Jan
9
comment Does ORDER BY on a clustered key effect performance?
@JNK added to question
Jan
9
revised Does ORDER BY on a clustered key effect performance?
added 56 characters in body
Jan
9
asked Does ORDER BY on a clustered key effect performance?
Jan
6
comment Does MS Access have anything equivalent to triggers?
If you're using triggers you're already risking differences in how databases act. Little projects like this grow, someone needs to give you access to or get you an Oracle test DB.
Jan
6
comment What can cause [DataDirect][ODBC Oracle Wire Protocol driver]Connection refused.?
Do the steps here help?
Jan
6
comment Should developers be able to query production databases?
I see Two Face is now a DBA :)
Jan
6
comment Should developers be able to query production databases?
Yep, the only things I do in the production database are exporting data and fixing support stuff.
Dec
30
revised How should row-specific metadata be created handled for an outer join view?
edited tags
Dec
30
asked How should row-specific metadata be created handled for an outer join view?
Dec
17
comment What Is The Point of a Primary Key?
@dportas I certainly agree that a system won't work well, but "need" implies that a table can not exist without a primary key, or that there is some operation preventing you from creating such a thing; there isn't. Perhaps there should be, but I've also seen people do the damndest things when creating keys; forcing people's hands can make them make terrible decisions as well. Also, I meant primary keys as the question asked, not just keys; my bad.
Dec
16
comment What Is The Point of a Primary Key?
@ypercube true, but that's not exclusive functionality to keys (unique constraints and indexes can fix that too), plus the point is everything still works. Whether it should work is another argument :)
Dec
16
comment What Is The Point of a Primary Key?
Something the answers don't make explicit is that you do not need a primary key to function correctly. PKs are vital for integrity and often helpful for performance, but ordinary data manipulation will work fine without them. That doesn't mean you shouldn't have them, however.
Dec
14
revised Top 2 rows per partition from an absolute value date difference
added 225 characters in body
Dec
14
comment Top 2 rows per partition from an absolute value date difference
For all my annoyance at our last programmer's use of procedural logic in queries, my current best working solution just loops through the cameras and grabs the nearest two images and is vastly faster (200ms vs over 3 minutes) than any solution I've tried with CTEs.
Dec
14
revised Top 2 rows per partition from an absolute value date difference
edited title
Dec
14
comment Top 2 rows per partition from an absolute value date difference
That only grabs the top two results period though, not the top two for each value of camera.
Dec
14
comment Top 2 rows per partition from an absolute value date difference
@JNK so am I. Searching 1 camera for this data takes <1 millisecond. With this method searching multiple cameras (3 in test) takes 3 minutes. I don't know how else to structure this though