UPDATE STATISTICS in SQL Server
In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table
Category: MSSQL
Send Email When the Blocked Session Count Exceeds a Certain Number in SQL Server
In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not
SQL Server Database Mail History Cleanup and Prevent msdb Database From Growing
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
Upgrade SQL Server
First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with
Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid class [0x80041010]
You may receive this error if you want to make a change in SQL Server Configuration Manager. Depending on the
How To Create a Linked Server To Connect To PostgreSQL From SQL Server
You may want to transfer data to MSSQL from PostgreSQL or send query to PostgreSQL from MSSQL. There are different
DBCC SHOW_STATISTICS in SQL Server
With DBCC SHOW_STATISTICS we can get detailed information about a statistic. As many of you know, statistics have one of
SQL Server Failover Cluster Takes Disk Offline
This is very interesting case. One day we saw that a database is not accessible in a failover cluster due
What is Incremental Statistics in SQL Server
Its is a feature announced with SQL Server 2014. It can be very useful if you have a partition in
How To Compress ColumnStore Tables and Indexes With COLUMNSTORE_ARCHIVE Option
COLUMNSTORE_ARCHIVE option was introduced with SQL Server 2014. If we want to archive ColumnStore Tables or Indexes, we can compress