Tag: t-sql

As you might have expected, since I chose Rube Goldberg Machines as the topic for this month’s T-SQL Tuesday, I have my own story to share. It was

T-SQL is not ideal for doing string manipulation, but sometimes you just need to get something done quickly with the tool you’ve got. A lot of people that

Cheers to Rob Farley ( blog | @rob_farley ) for hosting June’s T-SQL Tuesday #43, and for asking us to talk about plan operators. I read his host post a week

Thank you to Sebastian Meine ( @sqlity ) for hosting December’s  T-SQL Tuesday #37. He is writing a series about JOINs this month and asked for others in the community to participate with

Thank you to Nick Haslam ( blog | twitter ) for providing the topic for T-SQL Tuesday #35: What is your most horrifying discovery from your work with

I’m guessing that many developers, and novice to intermediate DBAs, are under the impression that they are golden if no error is returned when they press F5 (or

I was in need of a utility script to drop a handful of tables that started with the same prefix the other night, and had to quickly write

Duplicate data has a way of sneaking into database tables, so it’s nice to have a quick way to find and remove those duplicate rows. My favorite method