Nice light-bulb moment whilst reading that article Chandan. How many places could I have tried a filtered index in the past. Yeah I managed to come up with solutions that...

Thanks Deepam,

You have managed to translate Microsoft reference-documentation-speak into human-understandable english. Brilliant effort. These new functions look great. Admittedly I will have to look at the REGEXP_REPLACE one with all...

• This reply was modified 1 months ago by graham.nolan-753599.
• This reply was modified 1 months ago by graham.nolan-753599.

This article is one of the reasons I keep on reading the daily email feed. I have used SQL in a data warehouse setting for a long time but I...

I remember going out with the whole office to watch it fly over Bristol for the last time. We had a bulgarian working for us at the time who just...

Do you get joy from showing people how to go about doing a task? That 24yr old programmer in your team who soaks up what you are teaching them, the...

I'm doing the same although for my application I give the database 59GB out of 64GB for the ETL and then trim it down to 12GB to free up the...

Very useful reminder to look at the easy things to check first before searching for the obscure. Good article.

Graham