Posted inDatabase Administration A Curious Case of Orphan User Posted by By Ajay Dwivedi November 30, 2016 Hi Friends, Today at work I received an access request to provide multiple database permissions…
Posted inTSQL How do I verify if my login if set to Non-Expiry [SQL Server]? Posted by By Ajay Dwivedi November 28, 2016 Today I was working on multiple access/permission requests of same user on multiple servers. Due…
Posted inExecution Plan Performance Tuning TSQL Query Optimization 03 – Users statistics (individual user) [StackOverflow] Posted by By Ajay Dwivedi November 27, 2016 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. Posted by By Ajay Dwivedi November 24, 2016 Two days back while I am presenting in a KT session within team on how…
Posted inExecution Plan Performance Tuning Query Optimization 02 – Questions and Answers per Month [StackOverflow] Posted by By Ajay Dwivedi November 21, 2016 Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog…
Posted inTSQL Script to Analyze Mount Point Space & Generate Shrink File Statements Posted by By Ajay Dwivedi November 20, 2016 In my organization, we often receive far too many incidents for low free disk space.…
Posted inExecution Plan Performance Tuning Query Optimization 01 – What is my accepted answer percentage rate [StackOverflow] Posted by By Ajay Dwivedi November 14, 2016 I am very often asked on how to start query tuning which gave me an…
Posted inExecution Plan Performance Tuning Why my query is slow? Posted by By Ajay Dwivedi November 12, 2016 I often receive questions by developers and DBAs on how to find what's the issue…
Posted inDatabase Administration Errors SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion Posted by By Ajay Dwivedi November 3, 2016 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 Posted by By Ajay Dwivedi October 15, 2016 I have often seen Developers write predicate logic without bothering about performance. That works most…