Database Administrators Weekly Newsletter - Friday, October 31, 2014

Top new questions this week: Why would a table use its primary key as a foreign key to itself Looking through a database, I came across a table that used its primary key as a foreign key to itself. I've seen that a table can have a foreign key to itself to build a hierarchy structure, but it ... sql-server foreign-key primary-key   asked by Aaroninus 10 votes answered by Kenneth Fisher 16 votes Does SQL Server ever delete old error log files? I know I can cycle the current error log easily by running sp_cycle_errorlog, but I'm wondering if SQL Server will ever delete the old/archived error log files at all. Can't seem to find an answer to ... sql-server error-log   asked by tuseau 6 votes answered by Kenneth Fisher 10 votes Query optimizer recommends adding index instead of using existing index I am trying to determine why the query optimizer in SQL Server is recommending creating a new index instead of using an existing index that appears to be sufficient for the query. First the table. ... sql-server index query-performance nonclustered-index   asked by Hooligancat 5 votes answered by ypercube 11 votes Partial db dump/restore A part of my database (PostgreSQL 9.3) relies on extra tables (ex. County, City, Town, ... ). I don't manage these tables, they are updated regularly by a third party. Each time I get a new full dump, ... postgresql restore duplicate   asked by ablm 4 votes answered by Erwin Brandstetter 2 votes Proving the usefulness of a specific index I'm looking for a way to prove that some recently added indexes are positively impacting a production system. I've collected some dmv statistics to show that the indexes are indeed being used ... sql-server performance index   asked by Reaces 4 votes answered by Aaron Bertrand 5 votes CTE works as expected, but not when wrapped into a function --testing table CREATE TABLE public.test_patient_table ( entity_id INTEGER NOT NULL, site_held_at INTEGER NOT NULL, CONSTRAINT entityid_pk PRIMARY KEY ... sql postgresql stored-procedures plpgsql cte   asked by Gob00st 3 votes answered by a_horse_with_no_name 6 votes Overlapping indexes I have two non-clustered indexes on one of my dbs and their definition are: CREATE NONCLUSTERED INDEX [NC_Index1] ON [dbo].[anyTable] ( [X] ASC, [Y] ASC, [Z] ASC ) INCLUDE (A , ... sql-server sql-server-2008-r2 sql-server-2012 index nonclustered-index   asked by Stackoverflowuser 3 votes answered by Remus Rusanu 2 votes Greatest hits from previous weeks: Is select * still a big no-no on SQL Server 2012? Back in the days of yesteryear, it was considered a big no-no to do select * from table or select count(*) from table because of the performance hit. Is this still the case in later versions of SQL ... sql-server sql-server-2012 select   asked by Piers Karsenbarg 30 votes answered by RLF 37 votes Why Does the Transaction Log Keep Growing or Run Out of Space? This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this: In SQL Server - What are some reasons the ... sql-server transaction-log   asked by Mike Walsh 62 votes answered by Mike Walsh 92 votes Can you answer these? Best implementation of Service Broker when multiple readers needs to read their own message I have implemented service broker using rusanu.com articles and advices. Now I need to implement the following scenario : The service broker will manage Many messages for differents workers and each ... service-broker   asked by Discorde 1 vote MDF/TempDB Growth, SQL Server 2005 Enterprise Here's my scenario: SQL Server 2005 Enterprise Records from Database A being added to Database B Size of Database A MDF file: 3.15 GB I have separate drives for Data, Logs, and System. I ran a ... sql-server sql   asked by user1541301 1 vote Ctrl-F1 shortcut stopped working in SSMS 2014 I've had the Ctrl-F1 query shortcut bound to sp_whoisactive for years (this technique is described in How to assign CTRL+F1 to sp_whoisactive in ssms 2012?). A few days ago, it stopped working: if I ... ssms keyboard-shortcuts   asked by Jon of All Trades 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