SQL Server 2008 Index Maintenance Rebuild vs Reorganize

Today, let us discuss on Index Maintenance on SQL Server. Indexes tend to get fragmented as the data gets updated. If the update is under the free space on page which was specified using Fill Factor of index creation or Rebuild then it would not be fragmented. The clustered index is the index by which…

Policy Based Management to check database recovery model to be Simple

Policy Based Management to check database recovery model to be Simple in Simple Steps: 1. Create a Condition based on a Facet of Database 2. Now Create a policy using the condition created above to evaluate on Demand 3.Now Evaluate the above policy to check any deviations: 4.Output will look like this, showing Red mark…

SQL Server 2008 Extended Events 2

SQL Server 2008 Extended Events 2: Now lets create a New Event Session to capture LongRunning Queries which are running for more that 10 seconds Now in this post we will write the details of the event Ringer Buffer and XML file. It is not necessary to write at both places but for this demo…