Category: DataBase

The huge problem for online services is that traditional SQL database managers don’t scale up when database sizes approach "exascale" – the tremendous and fast-growing repositories needed by services like Facebook and Twitter. There’s nothing conceptually wrong with SQL, it’s just that the underlying RDBMS architecture does not perform well with these tremendous workloads. Simpler database constructs can handle bigger workloads, as long as the work they do stays more along the lines of simple storage and retrieval and doesn’t get too analytical. Today, a new vendor named DataStax whose backers include Rackspace is launching a commercial rendition of an […]

Reduce the transaction log size To recover from a situation where the transaction logs are full, you must reduce the size of the transaction logs. To do this, you must truncate the inactive transactions in your transaction log and shrink the transaction log file. Note The transaction logs are very important to maintain the transactional integrity of the database. Therefore, you must not delete the transaction log files even after you make a backup of your database and the transaction logs. To make sure you don’t delete any crucial parts of the database, it might be worth allowing a professional […]

Attach database failed for Server because the database is read-only Scenario: When you install any SQL DB based application, the default SQL DB goes into the respective SQL server ProgramFiles folder (like C:Program FilesMicrosoft SQL ServerMSSQL.5MSSQLDATA in case of SQL Server 2005 Express). However, you would like to relocate the DB to a different path that can scale up to the limits of DB growth estimated. When you copy the SQL DB to a different location, and try to attach the DB it will fail with below error:   TITLE: Microsoft SQL Server Management Studio Express —————————— Attach database failed […]