Posted inInternals Performance Tuning TSQL
Non – Trusted Foreign Keys in SQL Server
Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait…
Easy Trick to Debug Long TSQL Codes
In my previous organization, working as Senior SQL Developer, I was often asked for help…
Posted inTSQL
Create/Restrict Data Files – Automation
In my organization, as part of our strategy we keep Data files in 2 TB…
Posted inPerformance Tuning TSQL
Optimize for Value – TSQL Query Hint
Today, I was working on an incident of slow running procedure. Procedure was running fine…
![How do I verify if my login if set to Non-Expiry [SQL Server]?](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/11/Login.png?fit=945%2C182&ssl=1)
Posted inTSQL
How do I verify if my login if set to Non-Expiry [SQL Server]?
Today I was working on multiple access/permission requests of same user on multiple servers. Due…
![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 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.…
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…
Posted inTSQL
Get Decimal Scale Based on Variable Value
In recent past, while designing a report mailer I faced a requirement where I had…
Posted inTSQL
Query Shorcuts SQL Server SSMS – Get Max Data Length
There are multiple articles on internet regarding Query Shortcuts in SQL Server Management Studio. So I…