9,396 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 1 month
seen 2 hours ago

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Mar
9
reviewed Close Changed password on Postgres but I still can log in with the old one
Mar
9
reviewed Leave Open How do I Delete A Database And Log Files With SQL 2008 Script?
Mar
9
reviewed Leave Open Management Studio won't recognize other file extensions
Mar
9
reviewed Leave Open What does “InnoDB stores its tables and indexes in a tablespace” mean?
Mar
9
reviewed Close SQL Server - Same query, same database, different results
Mar
9
reviewed Close can't connect to postgresql with md5
Mar
9
reviewed Leave Open Export synonyms content to tables
Mar
9
reviewed Close Managing SQL Server 2008 R2 transaction logs when using principal/mirror databases
Mar
9
reviewed Leave Open Beginner table design
Mar
9
reviewed Leave Open New field based on sum field
Mar
9
reviewed Leave Open MariaDB Galera Cluster
Mar
9
comment MariaDB Galera Cluster
Did you change wsrep_sst_auth on both machines, or just one? I don't think server X's setting being wrong will stop X from connecting to and synching from Y... I think X's setting being wrong will stop Y (or any other node) from synching from X... the donor node's setting is relevant with innobackupex, not the joining node.
Mar
9
reviewed Leave Open Drastic performance difference in View Dependencies between SQL Server 2005 and 2008 R2
Mar
9
reviewed Close SQL Server 2012 Database Engine Configuration Storage type Raid
Mar
9
comment mysterious load on server due to mysql
@JensW. makes a very good point. Verifying the RAID array would not only potentially make performance terrible, it could also give the illusion that MySQL was the cause when in fact it's only a symptom of the impaired I/O performance. Until the storage array is in a fully normal state, with everything it displays being correctly understood, tinkering with MySQL will be a waste of time.
Mar
8
reviewed Close Choosing between single table and multiple table database scheme
Mar
8
reviewed Close Converting a Ruby on Rails site from MySQL to PostgreSQL?
Mar
8
reviewed Leave Open Which one is better way to insert data?
Mar
7
reviewed Close How to create an efficient, scalable, multi-tenant data layer using MongoDB?
Mar
7
reviewed Leave Open SQL Server query used new index until this morning