Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
3
Newest
 Supporter
Impact
~2k people reached

  • 0 posts edited
  • 0 helpful flags
  • 33 votes cast
Dec
31
answered Reasons for avoiding large ID values
Sep
9
comment Master and Read Only Oracle Database synch is unacceptable
As a large system Oracle DBA who spent 8 months getting Quest SharePlex (probably the gold-standard for fast-as-you-can-get replication) to work reliably, I can assure you that what you're asking for is extremely expensive and very hard to do. One of many scalability ironies... what is simple with a single user system becomes astronomically complex with multiple users.
Sep
9
comment How do I tactfully bring up database shortcomings?
The weekly shrink and reindex sounds like a naive "solution" to a performance problem. The app with the db_owner role again, sounds like a "quick-fix" to satisfy impatient management... the same management you want to talk to about what was done wrong maybe? Think about that.
May
28
comment Crow Feet notation and identifying -vs- non-identifying relationships
An Entity-Relationship Diagram (ERD), of which "crows-feet" is just one type of notation, describes only the relationship between entities. The Primary Key (PK) of an entity can normally be inferred from that but there are things you can do in creating a PK that are not clearly reflected in an ERD. By making the Book PK consist of the Author PK plus something else that is not a foreign-key (FK) (you didn't what) you are describing one of those. It would be much more flexible to just use auto-generated sequence numbers for the FKs of all tables.
Jul
17
comment Mysql key_buffer_size already 16GB but some fulltext searches are still slow
This will sound counter-intuitive, but learned from working with large data with high demand a few years ago that buffers can be too big. Searching memory buffers usually does not use the highly-optimized-for-speed techniques employed for disk access as it's unnecessary. Today's memory buffers though are as big as disks of just a few years ago. There's a point of diminishing returns where a smaller buffer will actually be faster.
Jun
12
awarded  Supporter
Apr
17
answered Why are constraints applied in the database rather than the code?
Mar
27
awarded  Teacher
Mar
27
answered In what data type should I store an email address in database?
Nov
23
awarded  Autobiographer