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 inTSQL
Create/Restrict Data Files – Automation
In my organization, as part of our strategy we keep Data files in 2 TB sized Mount Point Volumes named like 'Data','Data01','Data02' etc. on E:\ drive. Similary, for Log files…
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…
Posted inDatabase Administration
Setup fresh/Scriptout Existing Mirroring on SQL Server
In my current organization, we have lot of servers where database mirroring is used as a disaster recovery option. Either we are setting up mirroring from scratch or dropping the…
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 for most of the parameter values but, was getting stuck for few values. I could…
![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 post Questions and Answers per Month, we took optimization decision by analyzing warnings suggested by…
![Query Optimization 02 – Questions and Answers per Month [StackOverflow]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2016/11/Sort-Spill-01.png?fit=576%2C349&ssl=1)
Posted inExecution Plan Performance Tuning
Query Optimization 02 – Questions and Answers per Month [StackOverflow]
Hi Friends, this is my 2nd blog post of series Query Optimization. In 1st blog post What is my accepted answer percentage rate, we took optimization decision based on Logical…
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. As part of resolution we have to check for unexpected files/folders on the mount point…
Posted inErrors Internals Performance Tuning
Performance Tuning With Predicate Logic
I have often seen Developers write predicate logic without bothering about performance. That works most of the time. But what about queries that return huge data sets? Is there any…
Posted inTSQL
Get Decimal Scale Based on Variable Value
In recent past, while designing a report mailer I faced a requirement where I had to convert a float column into DECIMAL with dynamic precision value coming from outside of…