SQL Server 2008 Update Statistics and Index Rebuild: Whenever a Index is rebuild the statistics are updated but not for…
Recovery Point Objective(RPO) describes a point in time that data can be restored from. For instance, if there is data…
ASYNC_NETWORK_IO Waits SQL Server 2005 2008 2012 2014 2016 ASYNC_NETWORK_IO Wait type in SQL 2005 2008 2012 2014 or 2016…
CXPACKET Waits and High CPU Usage Bottleneck SQL Server 2008 2012 2014 2016 When you suspect SQL Server is waiting…
The SQL Server Wait Types with their descriptions Wait Statistics in SQL Server indicate sql server performance in relation to different…
To check where the connections are made to database the below queries are have been very helpful. -- Get a…
Different Restore options in SQL Server 2008: 1. Restore can be done for an entire database from a full database…
Different Backup options in SQL Server 2008: 1. Backup’s can be taken for a complete database, or one or more…
BACKUP LOG WITH TRUNCATE_ONLY is no longer a recognized BACKUP option. This command get rid of the contents of your…
Before we go into SQL Server 2008 Authentication modes, it is better to have quick look at Active Directory Services.…
This website uses cookies.