SQL Server is used widely for the management of database. It is possible that the data gets corrupt due to different reasons. Therefore, to deal with this issue SQL Server has a command, which act as a manual solution for corruption of the database. This command is referred as DBCC…

There are so many facilities and amenities in SQL Server along with built-in methods, which assist users in some bad situations. It is possible that sometimes SQL server put the users in annoying circumstances when it becomes very difficult for them to access the database. At such situations, the very…

In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation. You can see the spikes occurring every minute.

This post is about how to rename a stand-alone SQL server instance. There could be some reasons to do that: You simply forgot to change the name of your Sysprep server or You want to change from the default instance name to another and etc.

The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log pages as well as the information for the transaction log. Detailed information about the checkpoint can be found here.

In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you have to have a resource (your database server).

Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and SQL Server Authentication. The new options are available only for the Database Engine:

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns TRUE or FALSE based on the logical operators.

CHECK constraints are similar to FOREIGN KEY constraints in that they control the…

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take…

A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the "Compare Showplan" option you're already having the comparison.

Example

If you want to switch the orientation to vertical, then you have an option "Toggle…

This spackle hints toward installation of the SQL Server 2016 SSMS. The installation of SSMS 2016 is different and it's a separate installation. It's not a part of the SQL Server installation as it was the case until SQL Server 2014.