Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Error/Fix: Msg 924. Get Database Out of Single User Mode
Losing single_user database connection is painful, and this script helps to regain the database access by getting database back to multi_user mode.
Posted inErrors
Error/Fix: Database cannot be upgraded because it is read-only or has read-only files
Yesterday during my online SQL Server class, I was trying to attach 10 GB size version of StackOverflow database that I used previosly with another instance. When I executed below…
Posted inErrors
Error/Fix: Cannot initialize the data source object of OLE DB provider “OraOLEDB.Oracle” for linked server. (.Net SqlClient Data Provider)
Recently I was working on one user request to create a linked server for Oracle database in SQL Server 2014 instance. After installing the correct Oracle ODBC drivers, when I…
Posted inErrors
Error/Fix: There is insufficient system memory in resource pool ‘default’ to run this query.
Recently I was reading about Temporal Tables feature that has been introduced with SQL Server 2016. So, as usual, I thought to get the knowledge in practice with my virtual…
Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
Recently I was working on a SQL query in my inventory database, and was greeted with below error message:- Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the…
Posted inErrors
Error/Fix: The database owner SID recorded in the master database differs from the database owner SID recorded in database
Recently I received an incident for low disk space on mount point dedicated to system databases on development sql server. So I started checking SQL Server Error logs to find…
Posted inDatabase Administration Errors
Error/Fix: The Extended Events session named “blocked_process” could not be found.
Two days back while I am presenting in a KT session within team on how to use Extended Events for trapping blocking and deadlocks, and use the SQL Sentry Plan…
Posted inDatabase Administration Errors
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
Yesterday, I was working on my office laptop with SQL Server which was installed previous day only, when all of a sudden I received message of machine getting restart due…