Tag Archives: T-SQL

Capturing My Own Metrics: #SQLNewBlogger

A customer was trying to compare two tables and capture a state as a performance metric. In this case, they were wanting to use Redgate Monitor and custom metrics, but since the tables were in a Memory-Optimized table, they couldn’t … Continue reading

Posted in Blog | Tagged , , | Leave a comment

T-SQL Tuesday #200: When I Look at a Query …

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound big, but this is a monthly party (started by Adam Machanic). We have 12 blog party events a year. 200 means this has been running for … Continue reading

Posted in Blog | Tagged , , , | 3 Comments

Funny Money: #SQLNewBlogger

While wandering around the documentation looking for some Question of the Day topics, I learned something new about the money data type. This post discusses what I learned. Another post for me that is simple and hopefully serves as an … Continue reading

Posted in Blog | Tagged , , | Leave a comment

UNION vs UNIONALL: #SQLNewBlogger

While writing another post I realized my UNION query didn’t work as one might initiall expect, so I decided a short post was worth writing. This is based on a previous post on QUOTENME(). Another post for me that is … Continue reading

Posted in Blog | Tagged , , | 1 Comment