Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The answer to this question depends on the size of the database that you are running this command, the parameters you will use with …
Read More »MSSQL
Identity Key Problem and DBCC CHECKIDENT
A colleague today said they received an error like this: Msg 2627, Level 14, State 1, Procedure SP_name, Line 33 Violation of PRIMARY KEY constraint …
Read More »PieceMeal Restore
In the article named “FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)“, I explained the issue that we can restore only read-write …
Read More »Find the logical and physical database source that is experiencing IO problem
Interesting title, right? We may want to see the processes that are currently running, especially when there are problems. In these cases you can …
Read More »How do you know that a record is in Data Cache On SQL Server
How do you find out if a specific record in a particular table is in the Buffer pool / data cache or in the …
Read More »CHOOSE Function On SQL Server
Did you know the CHOOSE function in SQL Server? This function introduced with SQL Server 2012. [crayon-678061a0388ba300443080/] The CHOOSE command can provide practical use …
Read More »How To Create a Server Side Trace On SQL Server
The most practical way to prepare a Server Side Trace is to use the SQL Server Profiler. First, open Profiler, select the desired Events …
Read More »Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.)
ERROR: SQLServer Error: 17750, Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be …
Read More »Could not load package “packet_name” because of error 0xC0014062
ERROR: Could not load package “packet name” because of error 0xC0014062.Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E4D (Login failed for …
Read More »The database owner SID recorded in the master database differs from the database owner SID recorded in database
ERROR: The database owner SID recorded in the master database differs from the database owner SID recorded in database ‘database_name’. You should correct this …
Read More »