Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

Top new questions this week:

How to design this database to avoid cyclic dependency?

There are two tables: User Address User contains a reference to Address. Address contains the columns CreatedBy and ModifiedBy, which is reference to User. How do I design this database to avoid …

database-design  
asked by ZERO MILE 8 votes
answered by PollusB 5 votes

Choosing a database for storing large amount of data and allowing for thousands of writes

I am working on a project that has some serious requirements regarding its database and having hard time choosing the best solution. The details are: Database will easily reach tens of terabytes of …

sql nosql  
asked by Dimitar K 6 votes
answered by Nathan Jolly 4 votes

SQL Server 2008 automatic decimal rounding issue

The question is relatively simple. I need to calculate 3 columns where the mid results are huge decimals, and I'm running into a problem early on with SQL Server basically rounding the decimals …

sql-server decimal calculation  
asked by Kahn 6 votes
answered by gbn 7 votes

Why disabling a clustered index makes the table inaccessible?

When an index is disabled, the definition remains in the system catalog but is no longer used. SQL Server does not maintain the index (as data in the table changes), and the index cannot be used to …

sql-server index clustered-index database-internals  
asked by sarepta 5 votes
answered by Kin 2 votes

Maximum memory setting in SQL Server

I'm running SQL Server 2008 and a web based application, on a single dedicated server, with only 2Gb of memory available. As is noted elsewhere, SQL Server regularly takes up to 98% of physical …

sql-server sql-server-2008 sql-server-2008-r2  
asked by fixit 5 votes
answered by Scott Chamberlain 7 votes

Are SQL Server statistics stored in database or buffer pool?

Just wondering are statistics kept in the database but not in the memory? If I backup/restore the database from a prod server to a development server, would it keep the same statistics so that …

sql-server execution-plan statistics  
asked by Joy Walker 4 votes
answered by Remus Rusanu 10 votes

Restore exceeds licensed limit of 10240 MB per database. All I really need is the DB structure

I received a .bak file from a customer that I need to Restore, but the Restore exceeds licensed limit of SQL Server 2008 R2 10240 MB per database. All I really need is the DB structure. Is there a …

sql-server  
asked by Bruce U 4 votes
answered by mrdenny 10 votes

Greatest hits from previous weeks:

What are the main causes of deadlocks and can they be prevented?

Recently one of our ASP.NET applications displayed a database deadlock error and I was requested to check and fix the error. I managed to find the cause of the deadlock was a stored procedure that …

sql-server sql-server-2008 deadlock  
asked by Coder Hawk 25 votes
answered by BlackICE 18 votes

Is there any best way to reduce the size of ibdata in mysql.?

I have some Production servers whose ibdata increases in size day by day. It has already consumed 290GB of space. The tables in the servers are mostly InnoDB and there are high read and write …

mysql database-administration  
asked by Abdul Manaf 5 votes
answered by RolandoMySQLDBA 7 votes

Can you answer these?

Combining full-text-search queries

I have two tables in a SQL Server database with basic fulltext indexes: CREATE FULLTEXT CATALOG table1_catalog; CREATE FULLTEXT INDEX ON table1 ( name1 ) KEY INDEX pk_table1 ON …

sql-server full-text-search  
asked by Rasmus Faber 2 votes

Primary replica set server goes secondary after secondary fails

I have a 2 servers replica set that, after the secondary fails the primary goes into secondary mode while the secondary is in STARTUP2 (recovering). The problem with this is that I can't use the …

mongodb  
asked by Sergio Ayestarán 2 votes

How to decode a query on a composite unary-encoded attribute?

A good early paper on the topic of bitmap indexes is "Bit Transposed Files" by Wong et al, published in 1985. In all the query-decoding examples, it is left to the reader to understand how each …

bitmap-index  
asked by Iain Elder 2 votes
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