The Script to Check Reports and Subcriptions with Sorted results per last Run Date SELECT c.Name AS ReportName , rs.ScheduleID…
Adding SQL Server Data Collectors to SQL Server is very important for Troublshooting issues and Root cause analysis of many…
What is SQL Server Health Check? Why is it important? A SQL Server health check looks at all aspects of…
Database File Free space and checking Database Growth Trends is one of the important tasks for a DBA for Pre-Sizing…
To Check Active Connections to SQL Server Database grouped by User Below query is very helpful in finding the Total…
Moving system databases in SQL Server 2008, 2005 To move all the system and user databases from "C:Program FilesMicrosoft SQL…
How to check Log shipping status in SQL Server 2008: SQL server recovery model has to be Full recovery mode…
It occurred in production environment when I was Unable to Shrink Temp DB Size SQL Server 2008 eventhough nothing was…
In this post we will discuss various memory configurations in 64 bit and 32 bit installations of SQL Server: In…
A copy-only backup in SQL Server(any version like 2012 or 2008 or 2005) is taken in cases you do not…
This website uses cookies.