MSSQL

When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is solved when I follow the …

When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties, we receive this error. To …

We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with Database Scoped Configurations feature of …

What is DBCC FREEPROCCACHE in SQL Server We can reset all plans in the plan cache with DBCC FREEPROCCACHE. Thus, each stored procedure has to …

What is dbcc clondatabase in SQL Server DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database …

We have been able to use Control Server Permission since SQL Server 2005. You can use this permission as an alternative to sysadmin. But it …

Before SQL Server 2014, we were able to create an index in two ways by right-clicking on SSMS and clicking new index, or using the …

In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table or database basis. I recommend …

In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not go into details of this …

If you are using SQL Server Database Mail, your msdb database can grow undesirably. We can use the msdb.dbo.sysmail_delete_mailitems_sp procedure to clear Database Mail History. …