Category: Internals

Many times I have seen that DBAs feel like its OK to Shrink Log files in order to release space, and they perform this activity in SQL Agent

Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait stats on server, I found ‘LCK_M_X’ wait to be most prominent wait on

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