Top new questions this week:

One index or two?

I have the following index created on a table in my database: CREATE INDEX [idx_index1] on [table1] (col1, col2, col3) The server is suggesting the following 'missing' index: CREATE INDEX …

sql-server sql-server-2008-r2 index index-tuning

asked by paulH 6 votes answered by Thomas Stringer 8 votes

Broken tempdb location and can't recover

Made a mistake and mistyped an alter database command for tempdb. Now the instance won't start. I can't start in single user mode using -m as it states the tempdb could not be found. I tried using: …

sql-server-2008-r2 disaster-recovery

asked by Tim Alexander 5 votes answered by Aaron Bertrand 8 votes

Don't rebuild indexes < 1000 pages - then why bother having them?

Microsoft recommends not bothering to rebuild indexes that have less than 1,000 pages (from memory I think it's because they are so small that they will be held in RAM). If I'm not rebuilding them, …

sql-server-2008-r2 index

asked by paulH 5 votes answered by Remus Rusanu 14 votes

SQL Server 2012 performance issues (maybe due to linked server)

Summary of the problem We've spit our one database server environment into two servers. We are now having intermittent performance issues I am hoping someone can offer clues - perhaps direction …

sql-server performance sql-server-2012 linked-server

asked by Greg Bala 4 votes

Using SQL Snapshot Replication to refresh TEST databases from PRODUCTION. Why not?

What are the drawbacks and downsides? We want to schedule automatic nightly refreshes of 20 databases, approximately 1GB each, from the PRODUCTION server to the TEST server. We're setting up SQL …

sql-server replication snapshot

asked by Lawrence P. Kelley 3 votes answered by Kin 1 vote

PostgreSQL: FATAL: database locale is incompatible with operating system

I'd like to log in to PostgreSQL in my server to change my root (postgres) password . Debian GNU/Linux 7.1 wheezy PostgreSQL 9.1 After changing below: $ sudo vi …

postgresql

asked by sky_y 3 votes

Can't get this query to work (left outer join) Postgres

I've got this query I'd like to get working. I'm trying to count all the instances of a foreign key after a certain date that isn't null, and then left join that to the distinct of the original table, …

sql postgresql

asked by James 3 votes answered by bluefeet 7 votes

Greatest hits from previous weeks:

Why is Database Administration so hard?

I know a lot of Database Administrators and they are all over 28-29 years old. Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years? Or is …

database-administration learning management

asked by Soner Gönül 52 votes answered by Leigh Riffel 83 votes

MySQL DB import/export command line in Windows

How to export / import a database in MySQL through the command line? MySQL system configuration, WampServer server installed. OS: Windows The advice for my local host, not an live hosting...

mysql mysqldump

asked by Bharanikumar 20 votes answered by matei 29 votes

Can you answer these?

Splitting SQL Server 2008 database

I manage a 280gb SQL Server database. The structure contains a single database file and many schemas. Each customer has a schema and an associated set of tables. so : MainDatabase : Schema1: …

sql sql-server sql-server-2008

asked by MWard 3 votes

Correct pg_hba.conf to allow script to run locally with a specific db-user

I've got a working postgreSQL database with following pg_hba.conf: local all postgres peer local all all …

postgresql postgresql-9.1

asked by stUrb 1 vote

Limiting PostgreSQL logging

I have a table that can contain reasonably large BYTEA values (the same could apply to large TEXT values). It looks like this: CREATE TABLE testtable ( id SERIAL PRIMARY KEY, name TEXT UNIQUE …

postgresql log

asked by Bruno 2 votes