NOLOCK Is Bad And You Probably Shouldn’t Use It.
I’m waiting for the YOLOck option.When you put NOLOCK in your query, SQL Server will: Read rows twice Skip rows altogether Show you changes that never actually got committed Let your query fail with an error This is not a bug. This is by design. …
Free Live Class This Week: Fundamentals of TempDB
You’ve been working with Microsoft SQL Server for a couple of years, and you know a little bit about TempDB. You’ve heard that temp tables and table variables have different performance characteristics than regular user database tables, and …
[Video] PASS Data Community Summit Keynote: 5 Ways the Cloud Impacts Your Career
Succeeding as a data professional is all about placing the right bets at the right times. The more you know about what’s happening around you, the better bets you can place. I’ve been working with databases for over two decades. In this ses …
[Video] Office Hours on the Balcony Part 1
I hang out on my balcony in San Diego with a gin & tonic and a bunch of your highly upvoted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 01:33 FishCakesForTea: I have designed a filtered index fo …
Stats Q&A 2: Updating SQL Server Statistics
Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating multiple posts to answer them. This second post is dedicated to questions specific …
SQL Server 2022 Slogan Contest Winners
Last week, I challenged y’all to come up with slogans for SQL Server 2022. I have to confess that when I came up with the idea for that blog post, I thought y’all would take it seriously. I thought you’d come up with ideas that were m …
Stats Q&A 1: Creating SQL Server Statistics
Last week I presented a session, Demystifying Statistics in SQL Server, at the PASS Community Summit, and I had a lot of great questions; so many that I’m creating multiple posts to answer them. This first post is dedicated to questions specific …
Free Live Class This Week: Fundamentals of Columnstore
Your report queries are too slow. You’ve tried throwing some hardware at it: your production SQL Server has 12 CPU cores or more, 128GB RAM, and SQL Server 2016 or newer. It’s still not enough to handle your growing data. It’s already …
Is Microsoft SQL Server 2022 a Big Release?
Normally when y’all post questions here on Pollgab, I let ’em pile up and I eventually do an Office Hours webcast where I talk through my answers. I check in on the list every couple of days just out of curiosity, though, and one of ’ …
Updated First Responder Kit and Consultant Toolkit for November 2021
Just like you, the First Responder Kit has been pretty much stable for the last couple of months. There have been a few small changes, but nothing too big. There are a few pending pull requests that folks are working on around an open source setup …
Contest: SQL Server 2022 Needs a Slogan.
Now that Microsoft has announced that SQL Server 2022 is coming, it’s time for us to talk about a shameful truth: SQL Server doesn’t sell itself. Remember when everybody was talking about how MongoDB was Web Scale™? Or when Oracle was …
There is a Ton of Free SQL Server Training Coming Up.
If you don’t get smarter soon, it’s your own damn fault. Oh sure, I’m running a Black Friday sale, but even if you’re as broke as SSMS’s live query plans, you can still afford this free stuff I’m doing: Weds-Thurs: Q …
[Video] Office Hours Manhattan Edition: Ask Me Anything About SQL Server
I sat down on the edge of Brooklyn, overlooking the Manhattan skyline, to take your highest-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Introductions 00:42 Dylan: Do you have any experience with sys.dm_db_t …
[Video] Office Hours Speed Round: Quick Answers
Think fast! Not all of the questions at https://pollgab.com/room/brento have long-winded answers. In this 5-minute session, I crank through a bunch of straightforward questions: 00:00 Introductions 00:32 Mike: Hi Brent, the delete job is blocking for a …
Who’s Hiring in the Database Community? November 2021 Edition
Is your company hiring for a database position as of November 2021? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment m …