I have received this query on my fb last night ,One of my friend asking me to how can I
Continue readingPerformance Tunning :- Find I/O Usage Per Databases in SQL Server
Through Below Script you are able to identify the I/O utilization By per databases in your SQL Server.The information returned
Continue readingPerformance Tunning :- How to find out CPU Uses By each Databases in SQL Server
Through Below Script you are able to identify the CPU utilization By per databases in your SQL Server:– WITH CPU_Uses_Per_Db
Continue readingHow to check status on Database Shrink Task in SQL Server?
Through Below Query we can check the status of database Shrink Operation :- SELECT percent_complete, start_time, status, command, estimated_completion_time, cpu_time,
Continue readingDifference Between Log Shipping and Database Mirroring
Log Shipping:- It automatically sends transaction log backups from one database On another server. T-Logs are backed up and
Continue readingHow to find out Who dropped login from SQL Server?
Through below script we are able to find out who is culprit for this activity:- ============================================================== DECLARE @enable INT SELECT
Continue readingRecover Database from Suspect Mode in SQL Server
Today morning I observed that one of our logshipped secondary database reached into Suspect mode, I just investigated and found that log
Continue readingWhat MAXDOP setting should be used for SQL Server?
You can run the below query and identify the suitable MAXDOP for your SQL Server then you can set the
Continue readingHow to recover or attached a database which transaction log (.LDF) file is missing or corrupt?
There might be a situation due to some reason the transaction log file is corrupted or removed , But we
Continue readingFind All Logins Having SA(SYSADMIN) Rights to Access SQL SERVER
Through below query we can find out the logins having SYSADMIN Rights:-
Continue reading