The Deploy Outline function in Optimize SQL improves SQL statement performance without changing your original source code. Using Optimize SQL, you can generate SQL statements that are semantically equ...
Question: How to Get Status of Running Backup and Restore in SQL Server? Answer: One of the reasons I started my blog long ago was to have a repository of scripts which can be very useful by DBA duri...
I have heard many times from many DBAs that when a data block corruption happen in a disk which is part of a Diskgroup using normal redundancy, only the mirror block will take care of the coming datab...
