This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run -> Regedit -> HKEY_LOCAL_MACHINE -> …
Read More »
This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run -> Regedit -> HKEY_LOCAL_MACHINE -> …
Read More »With SQL Server 2016, support for automatic update statistics in Memory Optimized Tables is available. If the database is created with compatibility level 130, nothing is required. However, if the …
Read More »When I tried to open SQL Server 2017 Configuration Manager, I received an error like the following. My problem is solved when I follow the steps below. Error Cannot connect …
Read More »When we create a database through SQL Server Management Studio version 17.3 and right click on it and click properties, we receive this error. To continue using the new version …
Read More »We are able to configure some critical options set at instance level, such as MAXDOP, at the database level with Database Scoped Configurations feature of SQL Server 2016. Especially on …
Read More »What is DBCC FREEPROCCACHE in SQL Server We can reset all plans in the plan cache with DBCC FREEPROCCACHE. Thus, each stored procedure has to be recompiled because there is …
Read More »What is dbcc clondatabase in SQL Server DBCC ClonDatabase announced with SQL Server 2014 SP2. We are able to create a copy of the database without data to analyze query …
Read More »We have been able to use Control Server Permission since SQL Server 2005. You can use this permission as an alternative to sysadmin. But it does not mean both are …
Read More »Before SQL Server 2014, we were able to create an index in two ways by right-clicking on SSMS and clicking new index, or using the tsql script. But we couldn’t …
Read More »In this article, I will explain you to how to update your statistics with the UPDATE STATISTICS command by table or database basis. I recommend that you read the article …
Read More »