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 inBaseline-SQL-Server Errors SQL Alerts
Find TempDb Space Consumers in SQL Server
Troubleshoot SQL Server tempdb database space issue and find out what sessions are consuming tempdb space.
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: Database Mails using Gmail getting to Unsent Items
Recently I tried to setup Database Mail profile in SQL Server 2016 instance using 2-Step authenticated GMail account. Even after setting up mail profile as per standard configuration (same as…
Easy Trick to Debug Long TSQL Codes
In my previous organization, working as Senior SQL Developer, I was often asked for help by fellow colleagues for identifying issues inside long and complex TSQL codes. Finding issues becomes…
Posted inErrors Performance Tuning
Analyzing Deadlock Issues
I often receive the question - what is the best way to find issues when client/user complaints of deadlock issues? Msg 1205, Level 13, State 51, Line 10 Transaction (Process…