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