Month: October 2025

T-SQL Tuesday 191 – String parsing (and why I hate intelligent keys)

2 Comments
Welcome to the delayed 191st T-SQL Tuesday. Our host is, once more, Steve Jones. This time, he asks us to write about our favorite string parsing. Which is an odd thing to ask: nobody ever said “I like doing string manipulation in T-SQL”. So instead of doing what Steve asked, I will provide some background, and they show some tricks that might make the task a bit less unpleasant. Why intelligent keys are anything but intelligent I am currently most known for my performance tuning and execution plan work. But when I started working with database, I actually came from…

Black Friday 2025

No Comments
It’s October. Almost time for the annual Black Friday tradition, where companies prove how large their regular margins are by giving deep discounts to all their customers. Since the margin on my SQLServerFast Execution Plan Video Training is 100% (if we conveniently fail to count the hundreds of hours of labour I put in), I can also jump this bandwagon. I have done so in previous years, and by now I guess my regulars almost expect me to. So, let’s not disappoint people. Like previous years, during the entire month of November 2025, all video purchases are discounted by a…

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close