Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

Top new questions this week:

What does Page Life Expectancy say about the instance?

I have installed monitoring software on a few SQL Server instances in the environment. I am trying to find bottlenecks and fix some performance issues. I want to find out if some servers need more ...

sql-server memory  
asked by Ɓukasz Kastelik 5 votes
answered by DBAFromTheCold 5 votes

Why can a non-clustered index not be dropped using online=on option

When attempting to drop a non-clustered index using the online option such as DROP INDEX [IX_MYINDEX] ON [dbo].[myTable] WITH ( ONLINE = ON ), I receive the following error message. Msg 3745, Level ...

sql-server sql-server-2008-r2 nonclustered-index  
asked by BateTech 5 votes
answered by Remus Rusanu 11 votes

When was a Database taken Offline

I am trying to find a way to figure out when was couple of my sql databases were taken offline. I checked the the logs but could not find any such info and moreover there is no default trace enabled. ...

sql-server sql-server-2008 database-administration  
asked by Kapil 5 votes
answered by Aaron Bertrand 4 votes

How to change default database to all logins?

I'm bit new to SQL Server and I'm trying to script out Microsoft SQL Server (2005-2014) post installation activities and I got bit stuck on altering logins. Corporate policy states that none login ...

sql-server t-sql database-administration logins  
asked by Ricky-Brno 4 votes
answered by Shawn Melton 3 votes

Take advantage of monotonic columns in PostreSQL

I have a PostgreSQL table with, among the other, two columns named col1 and col2, both of integer type (there are around 10M rows in the table). I want to perform SQL queries like: SELECT * FROM ...

postgresql query-performance query-plan  
asked by giomasce 4 votes
answered by Jack Douglas 3 votes

PostgreSQL operator uses index but underlying function does not

I'm attempting to use JSONB with JDBC, which means that I have to avoid any of the operators which use the '?' character (as the PostgreSQL JDBC driver has no escaping for this character). Taking a ...

postgresql index-tuning json postgresql-9.4 operator  
asked by jgm 4 votes

SQL Server 2012 memory consumption outside the buffer pool

I've got an instance of SQL Server 2012 SP2 Enterprise Edition consuming ~20GB of memory higher than the max. memory limit. The instance is limited to 65GB but the physical memory in use from the ...

sql-server  
asked by DBAFromTheCold 4 votes
answered by Aaron Bertrand 1 vote

Greatest hits from previous weeks:

Good explanation of cascade (ON DELETE/UPDATE) behavior

I don't design schemas everyday, but when I do, I try to setup cascade updates/deletes correctly to make administration easier. I understand how cascades work, but I can never remember which table is ...

mysql foreign-key  
asked by John Syrinek 15 votes
answered by ypercube 30 votes

How do I insert a row which contains a foreign key?

Using PostgreSQL v9.1. I have the following tables: CREATE TABLE foo ( id BIGSERIAL NOT NULL UNIQUE PRIMARY KEY, type VARCHAR(60) NOT NULL UNIQUE ); CREATE TABLE bar ( id BIGSERIAL ...

sql postgresql foreign-key postgresql-9.1 insert  
asked by Stéphane 7 votes
answered by ypercube 12 votes

Can you answer these?

Timestamp-based index

I have a big database (200GB+) that contains some log info. And I want to speed up SELECT queries and stored procedures. I have a table with a GeneratedOnUtc datetime column, and have a non-clustered ...

sql-server sql performance index clustered-index  
asked by Alex Joukovsky 3 votes

Grouping results with left and inner join with zero counts

I have a query like SELECT `campaign_question_options`.`text`, COUNT(`campaign_submission_answers`.`answer`) as `count` FROM `campaign_questions` INNER JOIN ...

mysql join group-by count  
asked by Bowen 1 vote

mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

I am troubleshooting a backup script (bash), and I have limited working knowledge of the current configuration since the last 3 predecessors did not leave any documentation. I do know that my server ...

mysql mysqldump debian  
asked by filoxo 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