Introduction This example i found quite useful. The current Syteline database I am administering peaked at 176Gb in size, and although we followed Infor’s sizing advise when acquiring the hardware (infact we doubled most of their suggestions), we were running out of space – especially if you wanted to restore […]

Introduction The “Select Into” statement is something I use on a regular basis, and something I have always insisted my team use prior to making any large data changes. The scenario  would be “I am about to make a major change to several thousand item records, the change is effecting […]

Introduction On a number of occasions, I’ve been asked for examples of stuff that seems really easy when you have been writing T-SQL for some time, but I wrote this quick query this afternoon and it brought memories flooding back to me of when I first started doing this sort of […]