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
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
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.
Today I was working on multiple access/permission requests of same user on multiple servers. Due to previous poor experience using sql authenticated login set to expiry by DBA,
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
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
There are multiple articles on internet regarding Query Shortcuts in SQL Server Management Studio. So I won’t cover details of SSMS Query Shortcuts. But to increase your productivity, I