I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO, has been missing. That is grouped string concatenation (ie forming a delimited string ) and string split ( breaking … Continue reading →
Read moreSometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have had to put a lot of time and effort into demonstrating the hows and whys. One of the easiest ( … Continue reading →
Read moreHi Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like to thank the team though for selecting my pre-con. Let me know if you would have liked to attend and … Continue reading →
Read more.. Is there something I should know, sang Duran Duran many moons ago when I was young and before I knew that query optimization was even a thing. But, it is quite a handy little line to keep in mind … Continue reading →
Read moreI have been working with SQL server for more years than I really care to mention and like to think that I am now quite comfortable with the internals, specifically the Query Optimizer. Every so often though a new problem … Continue reading →
Read more