TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns

It's T-SQL Tuesday time again, and this month the host is Kendra Little (b | t) whose topic of choice is Interviewing Patterns & Anti-Patterns TL:DR Version - Passion and Aptitude. When hiring someone, make sure they're passionate about the job and have the aptitude to learn and grow. My story starts when I was … Continue reading TSQL Tuesday #93: Interviewing Patterns & Anti-Patterns

identifying broken numeric sequences using SQL – Part 1 (Islands)

Sometimes a sequential chain of numbers gets broken, and sometimes you may want to identify where that break in sequence happens. Well if you’re looking for solution, here is the quick and dirty on how to get it done. In this 2 part series we’ll explore how to identify gaps and islands in your data. … Continue reading identifying broken numeric sequences using SQL – Part 1 (Islands)

IMPLICIT CONVERSION

When troubleshooting performance issues in SQL Server,one of the more common mistakes I come across are mismatched datatypes in predicates. This can cause a huge hit in performance and sometimes it won't make a difference at all. Check out my sample code below, and watch out for IMPLICIT_CONVERSION !!! /*Step 1 - Run this to … Continue reading IMPLICIT CONVERSION