I’ve wrote many scripts over the years to selectively reindex indexes and update statistics on Microsoft SQL Server. However more recently I’ve been using Hallengren’s SQL reindex script as it’s very powerful and pretty easy to use and schedule via […]

Frequently I use SQL with the work I do with Orbis Taskcentre. There’s some queries which I use quite a lot and have to always look up on the internet or work out how to do, so to save time, […]