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 topic. In this article, I …

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. Query Database Mail History We …

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 Assistant. You can find detailed …

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 are using, copy the following …

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 of method is linked server. …

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 the decision making of the …

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 we examine the event log …

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 have a partition, it won’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 with this option. For example, …

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 Online Index Rebuild operation. The …