Why Did My Clever Index Change Backfire? (free video)
Category:
execution-plans
, index-tuning
I had a great time giving a session recently for the 24 Hours of PASS - Summit Preview Edition.
You faked your resume... now what? (video with transcript)
Category:
database-administration
This week’s question from a reader: “How do I deal with interview questions asking about real-world scenarios when I’ve faked three years of experience on my resume?”
Hear my answer in this 14 minute video.
sp_query_store_flush_db, Query Store, and Backups
Category:
query-store
, query-tuning
One of the cool things about Query Store is that you can back it up with the database.
This isn’t perfect for every situation, because you must back up the whole database. If you’ve got a multi-terabyte database, your Query Store isn’t super portable! But still, it’s great to have an option.
How to Get Email Notifications for TSQLTuesday
Category:
tsql-programming
Lots of us want to write for TSQL Tuesday, but aren’t always on Twitter at the right time each month to see when the announcement comes out using the #tsql2sday hash tag. And maybe we have an RSS feed set up, but we often get behind on a big pile of posts to read. (Guilty!)
Recruiters, Nerves, and Saying No in Interviews (video with transcript)
Category:
database-administration
In this episode of “Dear SQL DBA”, I talk about three articles written by members of the SQL Server community on interviewing that I can’t stop thinking about.
Interviewing Patterns & Anti-Patterns: Advice from the SQL Server Community
Category:
indexing
Introduction
I’m glad I picked interviewing as the topic of TSQL Tuesday #93, because people wrote posts chock full of great advice and funny stories. Get ready to learn, be amazed, and laugh out loud as you read these posts, which I’ve indexed by the author’s first name. Don’t blame these authors for the dorky jokes in the cartoons, though. That’s all my fault.
Community Contributions
Aaron Bertrand is “looking back at bad interviews.” In the comments, I give a sure-fire way for you to handle any technical interview questions you don’t know.
Do Index Changes Remove Execution Plans from Cache?
Category:
query-performance
- Impacted query plans are NOT removed from cache at the time you change an index. The next time the query is executed, it will be recompiled, and the new plan and related execution information will be placed in cache.
- This is true whether or not the index is used by the query.
- Even if the index is on columns in the table which are not referenced by the query, the query will recompile on the next run.
To see this in action, you can play along with this sample script.