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


Feb
10
asked Single Identity column and composite key, which to make primary?
Feb
7
comment Is it more secure to go through a 3rd database to connect two databases using the same login?
You have an intermediary; those procs/views on the web DB. As long as your perms are set correctly the extra database seems like unnecessary abstraction with no security implications at all.
Jan
27
comment I have lots of free memory. How do I use it to increase performance?
Related sorta: dba.stackexchange.com/questions/8193/…
Jan
27
comment SQL Server - Multiple running totals
Our accounting system has had problems when running totals were stored in a separate physical table. Our vendor's software could update actual transactions without updating the actual balance table, resulting in an operating balance out of whack. A well designed system can avoid this, but be careful and consider how important accuracy is if you go the separate table approach.
Jan
11
comment 16 Cores 12 GB RAM server MySql Configuration - my.cnf
Does the server do the same thing when SELECTing only, no inserts? When it's the only request?
Jan
11
comment 16 Cores 12 GB RAM server MySql Configuration - my.cnf
Do only DB requests show this lag or does the web server itself have the lag? Are the DB and web server on the same physical/virtual box?
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 :)