Unlike some other languages, T-SQL doesn’t have the concept of a constant.
As good coders, we’ve all at some point tried...
2017-10-19 (first published: 2017-10-10)
In relation to the GDPR, I’ve recently been looking at the tools available within SQL Server to support auditing our...
2017-10-05 (first published: 2017-09-26)
I thought I’d do another chess puzzle this month. This one is a variant on the Eight Queens problem:
2017-09-01 (first published: 2017-08-22)
I mentioned in my previous post about manually updating statistics that you can specify whether they’re updated using a full...
2017-08-23 (first published: 2017-08-15)
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at...
2017-08-09 (first published: 2017-07-25)