Posts by Kendra Little

Q: Can High MaxDOP make a query SLOWER?

SQL Server
13 Comments
Answer: Yep, sometimes it can. I used to think that higher degrees of parallelism followed a law of diminishing returns– you could add more threads, but the benefits would taper off. But it’s a bit more complicated than that. Microsoft’s recommendation to be careful when setting maxdop to values over 8 is a warning worth heeding.…
Read More

Make SQL Apps Go Faster – Only 60 Seats Left!

#SQLPass
0
In just a few weeks, Brent, Jes and I will be giving a full day pre-conference session at the SQLPASS 2013 Conference in Charlotte, North Carolina. Our pre-conference will be Tuesday, October 15, 2013. There’s only a few seats left! This pre-con’s going to be killer– we’ve got 240 folks registered and ready to learn.…
Read More

You Can’t Kill Transactional Replication

Replication
181 Comments
Repli-Roach If SQL Server’s Transactional Replication was an animal, it would be a cockroach. It’s not pretty, but it’s resourceful and strong. Once you get even a small amount of replication in your environment it starts spreading everywhere. And if it gets out of control– well, in that case you’ve got no choice but to…
Read More

The Stages of Performance Tuning

SQL Server
2 Comments
Performance tuning is a weird art to learn, because you do it in public. Sure, you may puzzle over a technical problem at your desk or revise code on your own– but when it comes to really tuning hard problems, 99% of the time you’re doing it with other people. That’s the nature of real…
Read More

I’m ThatExcited about ThatConference

SQL Server
0
A peek into my slides for ThatConference I about to head out to a vast waterpark in the Midwest to ThatConference, where I’m going to hang out with 1000 developers, their families, and some wild animals.  I’m giving a session Monday called “How to Make Deploying Database Changes Fun Again”. I’ve had a blast distilling everything…
Read More

What?! Queries are Failing in My SQL Server?

SQL Server
41 Comments
Help is on the way I came across an interesting case recently where queries were failing in a high transaction SQL Server. We knew that queries were occasionally failing with error severity 20 because SQL Server Agent alerts were periodically firing. However, those built in alerts don’t capture exactly what has failed– they just say…
Read More

Optimize for… Mediocre?

Some query hints sound too good to be true. And, unfortunately, usually they aren’t quite as magical as they might seem. Frustration with unpredictable execution times People often learn about parameter sniffing when query execution times stop being predictable. Occasionally you’ll hear about a stored procedure taking much longer than normal, but the next time…
Read More