13,664 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 7 months
seen Aug 15 at 22:22

Oracle DBA, Unix admin.

Available for employment! ;)


Aug
10
comment Is this SQL schema normalized according to 3NF?
Why is it important that it is specifically 3NF? If it's a design for an actual live database, performance etc is paramount, not being textbook compliant.
Aug
10
reviewed Close How do tablespaces differ in DB2 from databases in MySQL or SQL Server?
Aug
10
reviewed Close Database with java query problem
Aug
10
reviewed Close Migrating SQL Server 2008 R2 to SQL Server 2014. What are the importing replication changes?
Aug
10
reviewed Close choose data from JSON
Aug
10
reviewed Close Count/Statistic for number of SHOW INDEX queries in MySQL/MariaDB 5.5
Aug
10
reviewed Close SQL where clause effect on table?
Aug
10
reviewed Close Updating data sets from Online databases/Webservice
Aug
10
reviewed Close best possible index on this situation
Aug
8
comment Order by for 2 row result causes 800% performance hit
Ordering a large set is computationally expensive.
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
since when were facts and technicalities involved in this question? :)
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
Are you running on Unix? The data might be in /dev/null
Aug
7
comment What is this view being used in my query?
Jonathan Lewis to the rescue: jonathanlewis.wordpress.com/2011/02/27/internal-views
Aug
7
comment What is this view being used in my query?
Edit your question with the full query plan.
Aug
7
reviewed Close Database going to Suspect mode
Aug
7
reviewed Close mysql server is not starting
Aug
7
reviewed Close Is there a simple, safe and low cost way to implement a (limited) database to be outside (close) IT control?
Aug
7
reviewed Close Dropped index from view still referenced in execution plans
Aug
7
reviewed Close All MySQL databases are unavailable because of a broken table
Aug
7
reviewed Close Duplicate Entry Error with PHP When Trying UPDATE