Top new questions this week:

Optimizing a CTE hierarchy

I apologize for double posting. Did not know there was a DBA subsection. I have a table of accounts with a typical acct/parent account architecture to represent a hierarchy of accounts (SQL Server …

sql-server optimization cte

asked by liver.larson 5 votes answered by Max Vernon 3 votes

Is Postgres ignoring my function cost annotation?

Why does this: create or replace function dummy() returns double precision as $$ SELECT random() $$ LANGUAGE SQL COST 777; explain select dummy(); return this: Result (cost=0.00..0.01 rows=1 …

postgresql stored-procedures postgresql-9.2

asked by Jim Hunziker 4 votes answered by bma 0 votes

SQL join query to show rows with non-existent rows in one table

I am trying to get some reporting done for employee time records. We have two tables specifically for this question. Employees are listed in the Members table and each day they enter time entries of …

sql-server sql-server-2008 join group-by reporting

asked by farewelldave 4 votes answered by Aaron Bertrand 4 votes

Poor query performance

We have a large (10,000+ lines) procedure that typically runs in 0.5-6.0 seconds depending on how much data it has to work with. Over the past month or so it has started taking 30+ seconds after we do …

sql-server sql-server-2008-r2 index-tuning index-statistics parameter

asked by eniacpx 3 votes

How Do I Troubleshoot Login Failed Errors In SQL Server?

What are some tips for troubleshooting SQL Server login errors? Questions like: How Do I see the full Error Message? My client just has a generic error message that says logon failed with no real …

sql-server

asked by Mike Walsh 3 votes answered by Mike Walsh 6 votes

if database is not shrinked does it affect backup size?

Ok my question is simple. Lets say that when i click database and hover over shrink it says it can be reduced 1 GB space. Now when i do a backup of this database, does this space also getting added …

sql-server sql-server-2012 backup optimization shrink

asked by MonsterMMORPG 3 votes answered by Aaron Bertrand 4 votes

Postgres log files not rotating

I have a postgres system with a hot standby server. They use the same config file. I've setup the log rotation to use log_rotation_size and log_rotation_age so that the master server is rotated every …

postgresql

asked by user2977516 3 votes answered by francs 0 votes

Greatest hits from previous weeks:

How do I change the DEFINER of a VIEW in Mysql?

When I run mysqldump, I get an error: mysqldump: Got error: 1449: The user specified as a definer ('root'@'foobar') does not exist when using LOCK TABLES This makes sense because foobar is a legacy …

mysql mysqldump privileges

asked by kfmfe04 9 votes answered by Manaf 8 votes

How to add sysadmin to user in SQL Server 2008 when no sysadmin accounts exist

I have a SQL server 2008 instance running. Unfortunately during testing I deselected the sysadmin rights for my login and now can't readd it (because I don't have sysadmin rights). There are no other …

sql sql-server sql-server-2008

asked by Mark D Jackson 8 votes answered by Damien_The_Unbeliever 5 votes

Can you answer these?

Postgres: PANIC: WAL contains references to invalid pages

I have a slave database that is being replicated from a Master DB. All of a sudden, my slave DB just exited and wasn't able to restart. Here are the error messages when it exits. Similar ones appear …

postgresql

asked by Henley Chiu 1 vote

Help with Mysql with 100K+ Table

Hi im trying to develop a database design in which its gonna have 100K+ tables residing in it. My major concern here is will Mysql be able to hold that much amount of tables with no performance …

mysql innodb performance-tuning

asked by Rohan 1 vote

SQL Error 3183 On SQL Server 2012

I have a backup of database version sql server 2008 R2 . while restoring it to SQL Server 2012 I am getting error msg 3183 RESTORE detected an error on page (6100:1886858449) in database ... . …

sql sql-server database-administration

asked by Nitesh Kumar 1 vote