Performance Myths: The query result cache

July 23, 2018 Andy 0

I was recently doing a training session when a developer commented that it was OK to run an expensive query twice because on the second execution, SQL Server would use the “results cache” and be “practically free”. It’s not the first time I’ve heard someone refer to a “results cache” in SQL Server. If you don’t know better, you might think SQL Server has a “results cache” because the second execution of a query is often faster.

TSQL Tuesday #104: dbo.Check_FileSize

July 9, 2018 Andy 2

It’s been a little bit since the last T-SQL Tuesday I joined, when I blogged about religion & politics. This month, I answer Bert Wagner’s call to blog about code I would hate to live without

Hanging up my DBA cleats

July 9, 2018 Andy 11

I’m no accidental DBA. Very shortly after I started working in tech, I realized that I wanted to be a DBA when I grew up. Eventually, I landed that DBA job, and have been a DBA ever since. A couple of weeks ago, I told my manager I was leaving and gave my notice. That night, my husband and I celebrated with a champagne moment.

How to get your dream job – Webinar recording

July 9, 2018 Andy 1

I recently presented for the PASS Professional Development virtual group with my session “How to get your dream job: resume & job hunting tips.” When I’m speaking at SQLSaturdays and User Groups, I frequently meet people looking to advance their career, make a career change, … [Read More]