Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
17 reads
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
764 reads
Are scalar functions really a bad thing?
I’ve read a lot of things lately pointing to scalar functions as if they were the devil. In this blog...
2018-09-18 (first published: 2018-09-10)
4,028 reads
Estimated Plans and Forced Plans from Query Store
While all plans are estimated plans, there is still a difference between capturing an estimated plan and looking at a...
2018-09-20 (first published: 2018-09-10)
1,765 reads
Redgate University is Growing
There isn’t a degree to be gained, but you can get a lot of information about Redgate products at Redgate...
2018-09-10
230 reads
Service Broker Target for Extended Events
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-09-20 (first published: 2018-09-10)
2,487 reads
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are waiting for a resource. No process can get the...
2018-09-10
16 reads
Different Ways to Handle Deadlock in SQL Server
Introduction To Deadlock
Deadlock in SQL server is a condition in which two or more system server processes IDS (SPIDs) are...
2018-09-10
2,768 reads
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
653 reads
SQL Server Automatic Tuning in the Real-World
In SQL Server 2016 we saw Query Store. Query Store was a game changer to help database administrators identify troublesome queries. Query Store helps DBAs make those queries run...
2018-09-10
60 reads
Blogs
Take Time to Gain Perspective
By Brian Kelley
Probably the best piece of advice I ever received is to take time to...
The Fringe Festival
By Steve Jones
I was lucky enough to take a vacation a decade ago in Edinburgh with...
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
Forums
Alamat Kantor BCA KCU BOGOR Tlp:08217555651
WA CS 628217555651 Jl. Ir. H. Juanda No.28, RT.03/RW.02, Paledang, Kecamatan Bogor Tengah, Kota...
Alamat Kantor BCA KCU Sukabumi Tlp:08217555651
WA CS 628217555651 Jl. A. Yani No.33-35, Gunungparang, Kec. Cikole, Kota Sukabumi, Jawa Barat...
Alamat Kantor BCA KCU Karawang Tlp:08217555651
WA CS 628217555651 Jl. Interchange Karawang Barat, Purwadana, Karawang, 41361, Purwadana, Telukjambe Timur, Karawang,...
Question of the Day
The SQL Server MCP Server
How do I get an MCP server for my SQL Server 2025 database from Microsoft?
See possible answers