Archive for the ‘MS SQL Server Recovery’ Category
MySQL uses MyISAM as the default storage engine, which is based on older ISAM code but comprises many useful extensions. The MyISAM comprises three files having extensions- .frm, .MYI, and [read full article]
Microsoft SQL Server, the most preferred back-end (database) utility among organizations because of its scalability, consistency, and familiarity with users. A user of SQL Server uses SQL Server Management Studio [read full article]
The DBCC DBREINDEX is a transactional-SQL command that reconstructs one or more indexes for a table in the SQL database file. Additionally, DBCC SHRINKDATABASE is a T-SQL command used to [read full article]
MS SQL Server is the most ordinarily used database client, can be subjected to corruption due to various logical and physical reasons. Let us suppose a situation when you are [read full article]
Microsoft SQL Server 2005 is designed with exceptional features of table partitioning with which you can utilize to enhance the performance of large databases as these partitioned tables are flexible [read full article]
Backup is the key to perform recovery of database objects after the database file gets corrupt. SQL Server provides you with a number, Log Sequence Number (LSN), which during the [read full article]