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 subscriptions

What's the difference between TRUNCATE and DELETE in SQL

sql database truncate asked Sep 26, 2008 at 13:53

stackoverflow.com

8 votes

Home B&W developing - very dark areas gone white

developing black-and-white fixer asked Sep 26, 2021 at 12:35

photo.stackexchange.com

5 votes

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

ruby-on-rails arrays ruby string asked Nov 18, 2015 at 10:22

stackoverflow.com

5 votes

ePub 3: Finding the Navigation document

epub table-of-contents asked Jan 22, 2018 at 9:36

ebooks.stackexchange.com

Top Answers

457

Fetch the rows which have the Max value for a column for each distinct value of another column

stackoverflow.com

313

What's the difference between TRUNCATE and DELETE in SQL

stackoverflow.com

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

stackoverflow.com

How do you interpret a query's explain plan?

stackoverflow.com

Proper way of checking if row exists in table in PL/SQL block

stackoverflow.com

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

math.stackexchange.com

How to choose and optimize oracle indexes?

stackoverflow.com

When and why are database joins expensive?

stackoverflow.com

take vs first performance in Ruby on Rails

stackoverflow.com

How can I query Rails ActiveRecord data stored in arrays

stackoverflow.com

MySQL vs. SQL Server vs. Oracle

stackoverflow.com

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

stackoverflow.com

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

stackoverflow.com

SQL to find the number of distinct values in a column

stackoverflow.com

Victorian Ship Weighing

worldbuilding.stackexchange.com

Should I index primary key column(s) in Oracle

stackoverflow.com

postgresql generate sequence with no gap

stackoverflow.com

Can We use threading in PL/SQL?

stackoverflow.com

PostgreSQL boolean cast (0 as false)

stackoverflow.com

How to store only time; not date and time?

stackoverflow.com

Keep order from 'IN' clause

stackoverflow.com

Generating Random Number In Each Row In Oracle Query

stackoverflow.com

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

stackoverflow.com

how to find partition of record oracle

stackoverflow.com

PL/SQL FOR LOOP IMPLICIT CURSOR

stackoverflow.com

Partitioning vs Indexes

dba.stackexchange.com

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

dba.stackexchange.com

Select count(*) from multiple tables

stackoverflow.com

Best beginner resources for understanding the EAV database model?

stackoverflow.com

Force index use in Oracle

stackoverflow.com