ShowPlan XML

I just ran into something that I hadn’t noticed in SQL Server.  It struck me as somewhat interesting but is really not too big of a deal. While demonstrating that the XML plan can be […]

PayPeriod Matching

Recently I was asked to alter a report to pull different more meaningful data.  The particular report was pulling data from the datawarehouse.  It had been recently modified to use a stored procedure (and subsequently […]

TSQL Tuesday – But I was Late

The puzzling problem I encountered in the article was a fun little job that kept giving different results than running the same code from SSMS. Check it out!