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…
Please read my previous post on SQL Server Locks and concurrency control before this.... Lock Escalations are there for a…
Today let us discuss more on SQL Server 20008/2005 Locks and concurrency control...... Locks are very essential to maintain concurrent…
Today lets discuss some of the SQL Server Storage internals like what is GAM, SGAM, IAM etc Basically in short…
Comparing ALTER INDEX options Index Rebuild and Reorganize: 1.Index Rebuild requires building the new index before dropping the old one.…
Today let us discus more on how SQL Server stores metadata (Data about Data) inside SQL Server: The metadata is…
Today, let us discuss on Index Maintenance on SQL Server. Indexes tend to get fragmented as the data gets updated.…
Policy Based Management to check database recovery model to be Simple in Simple Steps: 1. Create a Condition based on…
SQL Server 2008 Extended Events 2: Now lets create a New Event Session to capture LongRunning Queries which are running…
This website uses cookies.