Reputation
4,075
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
3 13 24
Newest
 sql
Impact
~203k people reached

May
25
reviewed Approve How to order by alphanumeric codes in SQL Server
May
25
revised Ongoing Administration comparison PostgreSQL vs Firebird
edited tags
May
25
reviewed Close Ongoing Administration comparison PostgreSQL vs Firebird
May
25
comment Ongoing Administration comparison PostgreSQL vs Firebird
You really need to tell us more about your requirements. For example, how will the DBMS be deployed: will this be an embedded DBMS in a product? Deployed on a server at one client? Many clients? Hosted? What data volumes do you expect? How many (concurrent) users? How will backups be managed?
May
25
reviewed Reviewed Creating Mview in Oracle is throwing error
May
25
revised Creating Mview in Oracle is throwing error
Removed chattiness.
May
25
answered How to remove data from multiple tables with different foreign keys without using ON DELETE CASCADE?
May
25
comment How to remove data from multiple tables with different foreign keys without using ON DELETE CASCADE?
Sorry, got it! Yet the semantics are what you're missing: It only deletes from "Users", not from the tables in the "using_list" -- they're purely listed to be able to join tables to determine which rows from "Users" need to be deleted.
May
25
reviewed Edit Merge row size overflow in SQL Server
May
25
revised Merge row size overflow in SQL Server
SQL isn't really relevant for this question.
May
25
comment How to remove data from multiple tables with different foreign keys without using ON DELETE CASCADE?
Where are you getting that syntax from? I don't see it described in the manual: postgresql.org/docs/9.4/static/sql-delete.html
May
25
comment Why is SELECT * much faster than selecting all columns (in a different column order) by name?
If I list all columns in the same order as defined in the table, I get approximately the same times as if I select *.
May
25
comment Why is SELECT * much faster than selecting all columns (in a different column order) by name?
I'm seeing differences also, though not as pronounced. My table has rows=514431 width=215, and I get approx 1.5s for the select * case and approx 2.2s for the select with columns listed in a different order.
May
25
reviewed Reopen Grouping based on the status, then count its product and the total based on its category ID
May
25
reviewed Close Database design question for sorta rookies
May
25
reviewed Close Certification Test 70-461
May
25
reviewed Close best software to run Oracle code
May
25
reviewed No Action Needed Why does MS SQL Server return a result for empty string check when Unicode string is not empty
May
25
reviewed Approve Grouping based on the status, then count its product and the total based on its category ID
May
24
reviewed Reviewed MySQL Cluster - Adding more storage space