MSSQL

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 …

Its is a feature announced with SQL Server 2014. It can be very useful if you have a partition in your database. If you don’t …

COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress our columnstore tables or indexes …

WAIT_AT_LOW_PRIORITY is a feature introduced with SQL Server 2014. We can control the Online Index Rebuild and switch partition operations. For example, suppose we perform …