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.
I’m headed to SQLSaturdays in Louisville and Columbus for my first community events as Product Manager at SentryOne. While I’m there, I’m interested in talking with SentryOne users.
The number of people who really love having their code [quoted] with [square brackets] is pretty small. The vast majority of people who I meet really hate them, and promptly remove them.
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
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.
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]