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…
Posted inErrors
Error/Fix: SQL Server has encountered 26063 occurrence(s) of I/O requests taking longer than 15 seconds to complete
Recently I received an incident for CheckDB job failure on one of our production server.…
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…
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…
Posted inErrors Internals Performance Tuning TSQL
Performance Tuning With Predicate Logic
I have often seen Developers write predicate logic without bothering about performance. That works most…