20,380 reputation
459112
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 7 months
seen 6 hours ago

Apr
28
reviewed No Action Needed SpringData MongoDB - infinite getmore on mongo logs
Apr
27
reviewed Reviewed constraint in oracle
Apr
27
reviewed No Action Needed Which one is correct and optimized in sql?
Apr
27
reviewed No Action Needed Upgrade MongoDB meta-data after binary upgrade
Apr
26
reviewed Approve suggested edit on Need help phrasing regular expression to find particular T-SQL pattern
Apr
25
reviewed Leave Open Generic script for stored procedure rollback
Apr
25
reviewed Reviewed Oracle Trace File Interpretation: enq: TX - index contention
Apr
25
reviewed No Action Needed result time long
Apr
25
reviewed Approve suggested edit on Limiting the Number of Records Joined
Apr
25
reviewed Approve suggested edit on result time long
Apr
25
reviewed Looks OK Numbering a rows positional index relative to its siblings within a parent context
Apr
25
reviewed Leave Open Word frequency query in Greenplum
Apr
25
reviewed No Action Needed How do you find home information for Oracle RAC on Unix?
Apr
25
reviewed No Action Needed Can't run subqueries on my server (MySQL)
Apr
24
reviewed Reviewed Oracle Automatic Memory Management - SGA_MAX_SIZE
Apr
24
reviewed Close How can I find out what makes my archived redo logs grown so fast
Apr
24
reviewed Approve suggested edit on How to Move All tables from one Database into Different Database?
Apr
24
comment Synchronization using triggers
@Yiping I hope I made it clear in my answer that I do not favour trigger code for this sort of requirement. Indexed views and constraints have important benefits. I'm not sure exactly what you mean by "business logic" (stored procedure? application-level code?) but the same fundamental issues exist, and you have to be very careful. If correctness is not actually rigorously enforced in the database, things can go wrong.
Apr
23
reviewed Reviewed best practice for 'staging' relation in stored procedure: use temp table, or view?
Apr
23
reviewed No Action Needed mongodb 2.6 mongos start up failed