MSSQL

  Lock Compatibility provides the necessary control when multiple transactions have the same lock request (row, page). If the resource is previously locked by a …

  SQL Server implements different types of locks that determine how concurrent query requests access the data. For example, imagine that one user wants to …

  The PAGELATCH_EX and PAGELATCH_SH wait types are errors that occur when writing to the same page in memory at the same time. These errors …

  We can use Backup Restore for many operations. Below you can find the most common reasons for using it. 1. To get a regular …

  Before you read this article, you need to know what the concept of partition is and how can we create partition for  a table. …

  As a high-level security measure in SQL Server, if you do not want application developers to know the application’s user password, this article will …

  If all the indexes in the partition table are not aligned according to the partition, you will get an error like the following during …

  Introduction A service broker is a high availibity technique in SQL Server which was introduced from SQL Server 2005. This is primarily to send …

  I explained how to create a partition int the article named “How To Create Partition On SQL Server“. In this article I will share …

  We can not take the backup of the database and transfer it to the test environment for security reasons. Because the actual data should …