MSSQL

  It is a setting made on windows so that SQL Server can work with higher performance. This setting can be made on Windows Server …

  We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …

  If you do not use a contained database, you must also move your logins when you move the database to another instance. You can …

  From the Security tab, right-click on Logins and click on new login. In the window that opens, we give a name to Login from …

  If you want to make a change in more than one session database at the same time, the control to prevent sessions from adversely …

  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. …