This custom sp rebuilds \ reorganizes indexes for SQL 2005 databases and logs results for further analysis.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.64 (11)

2011-03-25 (first published: 2009-02-16)

7,160 reads

SQL 2005 Disaster Recovery Scripts: To Setup and Remove Mirroring

Two sets of scripts to help setup mirroring or remove mirroring - handy during disaster recovery exercise

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (4)

2010-06-07 (first published: 2009-03-17)

2,594 reads

Blogs

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

This is one of those things that on hindsight was a stupid problem, but...

Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...

Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....

OK so I have a customer with a hosted website with eCommerce options. Essentially...