Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
10
Newest
 Scholar
Impact
~417 people reached

Sep
4
awarded  Scholar
Sep
4
accepted Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
Aug
4
awarded  Caucus
Dec
12
revised How to export an image column to files in SQL Server?
Fix markdown, remove erroneous COMMITs
Dec
12
suggested approved edit on How to export an image column to files in SQL Server?
Nov
23
comment Professor told us to store serialized Java objects as blobs instead of defining relational tables
What you should do is ask the professor why he's claiming this is better, listen thoughtfully to the answer, counter with the arguments above, listen to his response, etc. Engage.
Sep
24
awarded  Autobiographer
Nov
20
comment Minimizing possible trigger impact
@db2: Standard edition. Specifically, SQL Server Standard Edition 2008 R2 (v10.50.4285.0) 64-bit.
Nov
19
comment Minimizing possible trigger impact
@JonSeigel: Well, the above is a form of CDC. Not the form I'd prefer, but lacking a means of uniquely identifying a row limits my options. :-) Can you expand on how you'd expect log shipping, database snapshots, or snapshot isolation to apply? Absolutely open to options. I just keep coming back to that unique row problem. The odds of all columns having exactly the same value across two valid rows is small, though. (None of the key columns, even combined, can be relied upon in that way.)
Nov
19
comment Minimizing possible trigger impact
@billinkc: We don't, and we ought to have had. The trigger has been in place a while and things have been fine. (There was an earlier version of it that did all its work in the trigger [no staging, no sproc]. That...wasn't fine. :-) ) We've identified what we think may be an issue with the 3rd party product and I'm trying to rule out the trigger as a potential cause (and just generally keep it as lean as possible).
Nov
19
asked Minimizing possible trigger impact
Dec
21
awarded  Citizen Patrol
Dec
21
awarded  Commentator
Dec
6
awarded  Self-Learner
Dec
6
awarded  Editor
Dec
6
revised Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
add the engines a_horse_with_no_name mentioned
Dec
6
awarded  Teacher
Dec
6
answered Is there a major RDBMS that DOESN'T allow column name quoting/escaping?
Dec
4
awarded  Student
Dec
4
asked Is there a major RDBMS that DOESN'T allow column name quoting/escaping?