Tag: tsql

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

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

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.

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

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

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

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

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

Recently I worked on one optimisation job. It was procedure that processed multi-relationship data provided by clients in excel format, and created relationship tables. For example data like