Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Hello there, A query operation is performed on SQL Server. If the cursor is on the line, the data in that line is processed. DML …
Read More »MSSQL
@@SERVICENAME Function in SQL Server(TSQL)
You can find the name of the SQL Server Instance that you are connected to with the @@ SERVICENAME Function. If the instance you …
Read More »Set RegisterAllProvidersIP Value to 0 as Based on Availability Group
If you ran a validation report on the windows, a warning might appear. “The RegisterAllProvidersIP property for network name ‘Name: ‘ is set to 1. …
Read More »The constraint ‘PK_X’ is being referenced by table ‘X’, foreign key constraint ‘FK_X’
If there is a primary key foreign key relationship between two tables, you cannot delete the primary key without deleting the foreign key. When …
Read More »Could not drop object ” because it is referenced by a FOREIGN KEY constraint
When you try to delete the Primary table in tables that have a Primary Key Foreign Key relationship, you receive the error as follows. …
Read More »The INSERT statement conflicted with the FOREIGN KEY constraint
You can get this error when you want to inset data into a table that has the Foreing Key. It means that there is …
Read More »Setting the Database AUTO_CLOSE Option to OFF to Improve Performance
Auto_Close is an option of the database. If set to ON, the database is opened and closed each connection. The procedure cache is cleared …
Read More »@@VERSION, SERVERPROPERTY and @@MAX_CONNECTIONS Functions in SQL Server(TSQL)
The maximum number of connections that an instance can accept varies by version. With the @@MAX_CONNECTIONS function, we can query the number of default maximum …
Read More »Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail
You can receive this error even if you configure Database Mail and activate it via sp_configure. You can reach details in my article “How …
Read More »SET LOCK_TIMEOUT and @@LOCK_TIMEOUT Function in SQL Server(TSQL)
With SET LOCK_TIMEOUT, we can set the maximum amount of time a session will wait to access a blocked resource in milliseconds. If a …
Read More »