Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
What is a temporal table in SQL Server? We can store the history of inserts, updates and deletes by using temporal tables. Previously, we could …
Read More »
MSSQL
ON DELETE CASCADE and ON UPDATE CASCADE in SQL Server
We can use these statements together with the Foreing Key constraints. First of all, it is necessary to understand in detail what Foreign Key is. …
Read More »
What is Natively Compiled Scalar User-Defined Function(Udf)?
We are able to create Scalar User-Defined Function in SQL Server 2016 for Memory Optimized tables. For In Memory OLTP and Memory Optimized Tables, I …
Read More »
Generate In-Memory OLTP Migration Checklists(Objects in the Database is practicable to In-Memory OLTP?)
In this article, I will share What is Generate In-Memory OLTP Migration Checklists. If you want to learn What is In Memory OLTP and In-Memory …
Read More »
SQL Server Database Administrator’s Roadmap
In this article, I will describe the tasks and responsibilities of “SQL Server Database Administrator“. I will link to articles about how each item can …
Read More »
UpdateUptimeRegKey: Operating system error 5(Access is denied.)
This is because the user account that the SQL Server service is running on is not authorized in the MSSQL Registry files. Solution -> Run …
Read More »
Auto Update Statistics in Memory Optimized Tables
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 …
Read More »
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 solved when I follow the …
Read More »
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, we receive this error. To …
Read More »
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 Database Scoped Configurations feature of …
Read More »