Stack Exchange

David Aldridge

Haddenham, United Kingdom

http://generalproducts.co

Bibliocloud Data Architect

Business Intelligence Architect, PostgreSQL developer, Ruby on Rails Developer, Oracle Data Warehouser, Survivor of Informatica and Business Objects

Oracle ACE

top accounts reputation activity favorites subscriptions

Top Questions

What's the difference between TRUNCATE and DELETE in SQL

sql database truncate asked Sep 26 '08 at 13:53

stackoverflow.com

Ruby: Should strings in a frozen array also be individually frozen?

ruby-on-rails arrays ruby string asked Nov 18 '15 at 10:22

stackoverflow.com

Top Answers

Fetch the row which has the Max value for a column

stackoverflow.com

What's the difference between TRUNCATE and DELETE in SQL

stackoverflow.com

How do you interpret a query's explain plan?

stackoverflow.com

What is the difference between a hash join and a merge join (Oracle RDBMS )?

stackoverflow.com

Proper way of checking if row exists in table [pl/sql block]

stackoverflow.com

How to choose and optimize oracle indexes?

stackoverflow.com

How long will it take Marie to saw another board into 3 pieces?

math.stackexchange.com

When and why are database joins expensive?

stackoverflow.com

MySQL vs. SQL Server vs. Oracle

stackoverflow.com

take vs first performance in Ruby on Rails

stackoverflow.com

Data got committed in another/same session, cannot update row (Oracle SQL Developer)

stackoverflow.com

Victorian Ship Weighing

worldbuilding.stackexchange.com

How can I query Rails ActiveRecord data stored in arrays

stackoverflow.com

SQL to find the number of distinct values in a column

stackoverflow.com

Can We use threading in PL/SQL?

stackoverflow.com

ORA-04082: NEW or OLD references not allowed in table level triggers

stackoverflow.com

Should I index primary key column(s) in Oracle

stackoverflow.com

postgresql generate sequence with no gap

stackoverflow.com

Keep order from 'IN' clause

stackoverflow.com

Any performance impact in Oracle for using LIKE 'string' vs = 'string'?

stackoverflow.com

PL/SQL FOR LOOP IMPLICIT CURSOR

stackoverflow.com

How to store only time; not date and time?

stackoverflow.com

Best beginner resources for understanding the EAV database model?

stackoverflow.com

Generating Random Number In Each Row In Oracle Query

stackoverflow.com

Why are constraints applied in the database rather than the code?

dba.stackexchange.com

how to find partition of record oracle

stackoverflow.com

PostgreSQL boolean cast (0 as false)

stackoverflow.com

How many database indexes is too many?

stackoverflow.com

Oracle Joins - Comparison between conventional syntax VS ANSI Syntax

stackoverflow.com

SQL/Oracle: when indexes on multiple columns can be used

stackoverflow.com