Posted inInternals
Myth – Shrinking Log Files is OK
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 job. In…
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 stats on server, I found 'LCK_M_X' wait to be most prominent wait on server. This…
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…