Posted inDatabase Administration
A Curious Case of Orphan User
Hi Friends, Today at work I received an access request to provide multiple database permissions…
![Query Optimization 03 – Users statistics (individual user) [StackOverflow]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/11/Execution-Plan-02.png?fit=1024%2C576&ssl=1)
Posted inExecution Plan Performance Tuning TSQL
Query Optimization 03 – Users statistics (individual user) [StackOverflow]
Hi Friends, this is my 3rd blog post of series Query Optimization. In last blog…
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 inTSQL
Script to Analyze Mount Point Space & Generate Shrink File Statements
In my organization, we often receive far too many incidents for low free disk space.…