Thank you very much Markus 🙂

I'm using synonyms in testing at the moment to buy me a couple of days -- ideally enough time to learn how to implement a...

TheSQLGuru (10/10/2007)

---

I would go with at LEAST 30GB for OS partition - perhaps 40. Seems like EVERYTHING these days puts crap in the os part - especially the installer...

What monitoring tools you use will likely depend on what you want to get out of them...

Things for you to consider:

- what will you be monitoring?

(CPU/memory...

TheSQLGuru has made some good points.  Expanding on 3:

- the optimizer will choose to use an index for a query if it is determined to be "selective enough"...that is to...

If there are regular maintenance windows during which the database/SQL can be taken offline, it might be a good idea to take some time to defragment the filesystems where the...