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,…
0 Comments
November 21, 2019
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…
November 20, 2019
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,…
November 19, 2019
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…
November 18, 2019
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…
November 16, 2019
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…
November 14, 2019
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…
November 12, 2019
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…
October 24, 2019
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…
October 24, 2019
Upgrade SQL Server
First of all, upgrade is an important task. Before upgrading, you must check your database is ready to upgrade with…
October 23, 2019