SQL Server Education (by the geeks, for the geeks)
Hello Geeks and welcome to the Day 31 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
sys.dm_exec_requests – Day 31 – One DMV a Day Read MoreHi Friends, Here I am explaining a very general scenario about database backup. Problem : Suppose if we have a large database. The Backup process of this database will take long …
SQL Server – DATABASE Backup in terms of Percent_Complete Read MoreMany a times a DBA wishes for the below information, during performance troubleshooting, Can I get to know what was being executed 30 minutes back. Can I get to know which …
SQL Server: Why is it necessary to capture and store information on sessions i.e. spid(s) running on a SQL instance for troubleshooting purpose. Read More