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.


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
awarded  Outspoken
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
Feb
23
accepted Why is IDENTITY_INSERT ON only allowed on one table at a time?
Feb
23
accepted Does ORDER BY on a clustered key effect performance?
Feb
14
awarded  Nice Question
Feb
13
comment Single Identity column and composite key, which to make primary?
I agree with this generally, but as JNK points out I really don't need my surrogate key to even be a key (as long as I don't fudge the uniqueness).
Feb
12
comment Why is IDENTITY_INSERT ON only allowed on one table at a time?
@AaronBertrand But again, the duplicate ID risk is exactly the same on any table with IDENTITY INSERT on, why the hard limit? I think the fact that it persists only for the connection makes much more sense as a precaution.
Feb
10
comment Why is IDENTITY_INSERT ON only allowed on one table at a time?
@AaronBertrand it's not, as I implied in the Q. Not sure about deterrent either, since SQL Server allows lots of other bad practices like naming your columns with reserved keywords (sometimes even if you don't use []!)
Feb
10
revised Why is IDENTITY_INSERT ON only allowed on one table at a time?
added 74 characters in body
Feb
10
comment Why is IDENTITY_INSERT ON only allowed on one table at a time?
@RemusRusanu that's kind of what I was thinking, either that or to make sure you don't accidentally leave II ON for multiple tables.
Feb
10
asked Why is IDENTITY_INSERT ON only allowed on one table at a time?
Feb
10
comment Single Identity column and composite key, which to make primary?
@JNK True...none of that helps updates does it. I shouldn't ever need to select on it
Feb
10
comment Single Identity column and composite key, which to make primary?
@JNK No, it's syntactic sugar for my framework. All queries are done based on the composite key because the IDENTITY doesn't exist in my source table. So far as I've designed, the IDENTITY is never used except to update rows via the framework. Queries make extensive use of the composite key though, hence the clustered index to match the source table.
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?