Bad Query Performance Tips Rebutted
Once upon a time, someone, somewhere, wrote a list of bad query performance tips and they’ve been copied all over...
2018-11-20 (first published: 2018-11-12)
3,236 reads
The Scary DBA
What Is Happening, Right Now, At the PASS Summit?
Honestly, that’s a very hard question to answer. I mean, first of all, you can look at the schedule. There...
2018-11-05
205 reads
Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
3,990 reads
Why Did a Plan Get Removed From Cache?
I was recently asked if we could tell why a plan was removed from cache. If you read this blog,...
2018-10-26 (first published: 2018-10-22)
1,902 reads
Using Extended Events to Capture Implicit Conversions
Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices....
2018-10-24 (first published: 2018-10-15)
1,806 reads
Database Fundamentals #19: JOINS
The last Database Fundamentals post introduced the SELECT and FROM commands. We’re going to start using JOIN operations shortly, but...
2018-10-22 (first published: 2018-10-08)
2,968 reads
Adaptive Joins and Join Hints
At a recent all-day seminar on query performance tuning I was asked a question that I didn’t know the answer...
2018-10-10 (first published: 2018-10-01)
2,724 reads
Introducing Azure Data Studio
If you’re watching Microsoft Ignite or tracking the information coming out of it on social media, then you know that...
2018-10-02 (first published: 2018-09-24)
3,567 reads
Extended Events and Stored Procedure Parameter Values
One complaint I’ve received frequently is that you can’t see stored procedure parameter values in Extended Events. That is patently...
2018-09-24
501 reads
Databases and DevOps, It’s Not Just Me
Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows...
2018-09-19
316 reads
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Midjourney, Healthcare?
Comments posted to this topic are about the item Midjourney, Healthcare?
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers