The following article explains the key differences between Heap tables and Clustered tables. While working with tables in SQL Server, users often face the dilemma to use clustered tables or heap tables. Tables which don’t have clustered indexes...
Read more »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 »Learn the solutions for recovering a suspect MSDB database in SQL Server SQL Server agent makes use of msdb database for the purpose of scheduling jobs and alerts by making use of other features like SSMS, database mail, and service broker. There...
Read more »