< BACK TO TO THE MAGIC OF SQL SCRIPTS SERIES LIST
To be able to implement most of solutions that I would like to offer, you would need the following:
(1)
Create auxiliary database in the same instance of SQL server where your production database sits. This will be completely separate database which will not interfere with any data in your production environment. We will use this as a holding place for all sorts of data, information, configuration, etc which we will need throughout these series. I am not a DB expert - please consult your DBA or Google how to create Database. All you need is just a database similar to the below. All default settings, nothing fancy.