Reputation
6,130
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
11 30
Newest
 Enlightened
Impact
~421k people reached

Dec
13
awarded  Enlightened
Dec
13
awarded  Nice Answer
Oct
17
comment Performance: Postgres (Read-Committed) vs MySQL (Read-Uncommitted)
Install both and test.
Oct
10
comment Foreign keys - link using surrogate or natural key?
a) The term lookup table is informal. In the relational model, all tables are just tables. b) A table of US postal codes might have rows that look like this: {AK, Alaska}, {AL, Alabama}, {AZ, Arizona}, etc. Most people would call that a lookup table.
Aug
26
awarded  Nice Answer
Aug
1
awarded  sql
Jul
3
reviewed Approve What started this SQL Server job?
Jul
3
asked What started this SQL Server job?
Apr
13
awarded  Custodian
Apr
13
reviewed Reject How to get a working and complete PostgreSQL DB backup and test
Apr
9
comment COUNT(*) on InnoDB whenever phpMyAdmin loads
@Pacerier: Better link.
Apr
9
revised COUNT(*) on InnoDB whenever phpMyAdmin loads
Fixed broken link. Quoted source.
Mar
16
awarded  Nice Answer
Mar
1
awarded  Yearling
Oct
24
answered updating millions of rows in multiple tables sql server 2005
Sep
24
awarded  Autobiographer
Sep
9
awarded  Enlightened
Sep
9
awarded  Nice Answer
Sep
7
comment What is Atomic Relation in First Normal Form
No, atomic and repeating groups describe two different characteristics of relations with respect to first normal form. Considering the statement "If there are no repeating groups of attributes, then [the table] is in 1NF", Date says it (among others) is "at best, unclear and imprecise and, at worst, just plain wrong". See Date on Database, p 107f.
Jul
28
comment Large table with historical data allocates too much of SQL Server 2008 Std. memory - performance loss for other databases
What's the range of @b and @c? Is it the same all the time? Does it vary? If it varies, how much?