Update Nov 2021: This slack channel has been inactive for a bit of time now.
Are you a woman in technology that works with SQL Server or other databases? You might like to join our new slack channel - sqlwit.slack.com.
You know how sometimes you learn something, then you start to see it everywhere you look?
I primarily work with SQL Server, but my favorite book on TSQL is the one that I learned with: The Transact SQL Cookbook.
One perk to filtered indexes that may not be obvious at first is that you get an extra “dimension”– almost an extra kind of key column. This can be useful for some queries that can be tricky to index.
Like anyone else, I easily get wrapped up in my own life: my family and friends, my work, my local community, my technical community. Facebook, Twitter, cat pictures. When I took time off from work recently, I got a glimpse outside of my normal, narrow world.
It’s also for you, the speaker. Speaking takes up your time and energy. It teaches you to express concepts, to listen well, and it even teaches you a lot about how you think.
This is a super old command, but it still comes in handy when working with SQL Server.
Copyright (c) 2025, Catalyze SQL, LLC; all rights reserved. Opinions expressed on this site are solely those of Kendra Little of Catalyze SQL, LLC. Content policy: Short excerpts of blog posts (3 sentences) may be republished, but longer excerpts and artwork cannot be shared without explicit permission.