Database Administrators Weekly Newsletter - Friday, May 29, 2015

Top new questions this week: How often will a FOR EACH STATEMENT trigger execute if the operation is caused by an FK constraint with UPDATE CASCADE? I understand that a trigger on table t defined with FOR EACH STATEMENT will run once when I execute an UPDATE t .... Now, when t is defined with FOREIGN KEY ... REFERENCES a ... ON UPDATE CASCADE, ... postgresql trigger foreign-key postgresql-9.2   asked by Hanno Fietz 9 votes answered by Erwin Brandstetter 6 votes Why is SELECT * much faster than selecting all columns (in a different column order) by name? On a table with columns a,b,c,d,e,f,g,h,i,j,k I get: select * from misty order by a limit 25; Time: 302.068 ms And: select c,b,j,k,a,d,i,g,f,e,h from misty order by a limit 25; Time: 1258.451 ms ... sql postgresql postgresql-9.2   asked by Evgeny 8 votes answered by Amit L 10 votes SELECT DISTINCT on multiple columns Supposing we have a table with four columns (a,b,c,d) of the same data type. Is it possible to select all distinct values within the data in the columns and return them as a single column or do I ... sql postgresql postgresql-performance postgresql-9.4 distinct   asked by Fabrizio Mazzoni 5 votes answered by ypercube 12 votes Warning for missing statistics in execution plan I have a situation that I cant understand. My SQL SERVER execution plan tells me that I have missing statistics on the table, but the statistics is already created. Please see the screens. But if ... sql sql-server-2014 execution-plan statistics   asked by Artashes Khachatryan 5 votes answered by Aaron Bertrand 3 votes How to monitor history of logins to database if login auditing is not enabled? I have a number of databases on multiple servers that don't seem to be used any longer. Can't find their owners, there are no processes linked to them, nothing got written to the tables for a few ... sql-server logins   asked by The Confused DBA 5 votes answered by KASQLDBA 2 votes Deleting other files during maintenance plan I have an SQL Server 2012 maintenance plan which does the normal stuff (rebuild indexes and update statistics, back up DBs, deletes .bak files older than X days, etc). Everything is working fine with ... sql-server-2012 backup maintenance-plans   asked by DaveD 4 votes answered by KASQLDBA 3 votes Microsoft SQL linked server to Oracle data not updating I need to pull data from an Oracle database running on a remote machine and use it on my sql server instance. I need to check these tables periodically for updated or new records. I have created a ... sql-server-2012 linked-server oracle-sql-developer   asked by BenVlodgi 4 votes answered by BenVlodgi 2 votes Greatest hits from previous weeks: How can I time SQL-queries using psql? I would like to benchmark some SQL-queries agains my PostgreSQL database. Is there any way I can time SQL-queries using psql? postgresql benchmark psql   asked by Jonas 57 votes answered by Caleb 81 votes How to insert (file) data into a PostgreSQL bytea column This question is not about bytea v. oid v. blobs v. large objects, etc. I have a table containing a primary key integer field and a bytea field. I'd like to enter data into the bytea field. This ... postgresql   asked by SabreWolfy 13 votes answered by Jack Douglas 8 votes Can you answer these? pg_restore fails with materialized view I'm trying to pg_restore a db dump that contain a materialized views. If it is relevant, the materialized view is of a foreign data wrapper. It fails with the following errors: pg_restore: ... postgresql postgresql-9.4   asked by erikcw 1 vote Uninstalling MS sql server 2012 issues I'm trying to uninstall ms sql server 2012. But when I click Microsoft SQL Server 2012(64 bit) and choose remove option it shows like this. Then how can I remove the MS SQL Server 2012? Please help. ... sql-server sql-server-2012   asked by Leon 1 vote How to speed up for huge tables in SQL select query? I have the following huge tables. Table_1 with 500000 (0.5m) rows Table_8 with 20000000 (20m) rows Table_13 with 4000000 (4m) rows Table_6 with 500000 (0.5m) rows Table_15 with 200000 (0.2m) rows ... sql-server-2008-r2 query-performance t-sql performance-tuning   asked by user67445 1 vote

Subscribe to more Stack Exchange newsletters Unsubscribe from this newsletter or change your email preferences by visiting your subscriptions page on stackexchange.com. Questions? Comments? Let us know on our feedback site. If you no longer want to receive mail from Stack Exchange, unsubscribe from all stackexchange.com emails. Stack Exchange, Inc. 110 William St, 28th Floor, NY NY 10038 <3