Error When Opening SQL Server 2017 Configuration Manager([0x8004100e])
When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is
Category: MSSQL
legacy cardinality estimation is not a valid database scoped configuration
When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties,
Database Scoped Configurations in SQL Server 2016 and SQL Server 2017
We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with
DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS
What is DBCC FREEPROCCACHE in SQL Server We can reset all plans in the plan cache with DBCC FREEPROCCACHE. Thus,
DBCC clondatabase in SQL Server
What is dbcc clondatabase in SQL Server DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create
Restrict DBA From Viewing Data and Differences Between sysadmin and CONTROL SERVER in SQL Server
We have been able to use Control Server Permission since SQL Server 2005. You can use this permission as an
How To Create Index in CREATE TABLE Statement in SQL Server
Before SQL Server 2014, we were able to create an index in two ways by right-clicking on SSMS and clicking
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
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