MSSQL

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

First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with the help of Database Migration …

You may receive this error if you want to make a change in SQL Server Configuration Manager. Depending on the version of SQL Server you …

You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different methods to perform this. One …

With DBCC SHOW_STATISTICS we can get detailed information about a statistic. As many of you know, statistics have one of the most important roles in …

This is very interesting case. One day we saw that a database is not accessible in a failover cluster due to an offline disk. And …