SELECT * Hurts Performance, Badly
Quite a few years ago, I wrote a post about SELECT * and performance. That post had a bit of a click-bait title (freely admitted). I wrote the post...
2021-01-25
18 reads
Quite a few years ago, I wrote a post about SELECT * and performance. That post had a bit of a click-bait title (freely admitted). I wrote the post...
2021-01-25
18 reads
Reading execution plans in SQL Server is just hard. There’s a lot to learn and understand. I previously outlined the basics I use to get started when I’m looking...
2020-12-22 (first published: 2020-12-14)
467 reads
Building out processes and mechanisms for automated code deployments and testing can be quite a lot of work and isn’t easy. Now, try the same thing with data, and...
2020-12-03 (first published: 2020-11-23)
492 reads
If you’re attempting to implement automation in and around your deployments, you’re going to find there is quite a steep learning curve for DevOps and DevOps-style implementations. Since adopting...
2020-11-25 (first published: 2020-11-16)
193 reads
The purpose of a foreign key is to ensure data integrity by making sure that data added to a child table actually exists in the parent table and preventing...
2020-11-09 (first published: 2020-11-02)
213 reads
A lot of stored procedures have multiple statements and determining the most costly statement in a given proc is a very common task. After all, you want to focus...
2020-10-19 (first published: 2020-10-12)
843 reads
With all the stuff going on around the world over the last year, maintaining some degree of mental stability can be quite a challenge. Speaking only for myself, while...
2020-10-09 (first published: 2020-10-05)
345 reads
I love questions. Most of all, I love questions I can answer. I spotted this question recently: How can I use Profiler to capture execution plans for queries over...
2020-10-05 (first published: 2020-09-28)
470 reads
I was contacted by Stellar Info quite a while ago. They asked me to try out their software. I said yes, but I was really bad about getting it...
2020-10-01 (first published: 2020-09-23)
253 reads
I just received a question about Extended Events: What about filtering on the stored procedure name. You know I love writing and talking about Extended Events. The answer is,...
2020-09-04 (first published: 2020-08-24)
455 reads
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
(If you’d like to read my other T-SQL Tuesday Retrospective posts, click here.) In...
Hi all, We have 2 DMV's: sys.dm_db_index_usage_stats sys.dm_exec_procedure_stats And they don't look they can...
This is kinda hard to explain, maybe I can make sense of it. So...
Dear friends, Please, could you give me some ideas, how to implement SELECT count(*)...