Reputation
793
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 12 33
Newest
 Nice Answer
Impact
~134k people reached

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?
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.