The article explains in depth the use of Vertical Partitioning in improving the performance and maximizing I/O operations on a SQL server. Vertical Partitioning in SQL Server, an important feature introduced in SQL 2005 Enterprise Edition, is...
Read more »In this article we explain about ERROR 208, why it occurs and how to deal with it. We often come across situations which seem to be very complicated and challenging but are actually very easy to get out of; provided we think logically. One such...
Read more »If a database is read-only, you can easily identify the status from the sys.databases or from the SSMS. A well-known fact is that you cannot update data in a read-only database. In this article, we will learn how to troubleshoot and fix this. Two...
Read more »