SQL Toast

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

2018-07-30 (first published: 2018-07-20)

13,237 reads

Send SMS from SQL Server

We have configured email alerts in our environment. Recently I had requirement of sending SMS for critical alerts on production...

2014-03-31

1,950 reads

There is a way by which we can merge the .trc and .blg files to get a great view as...

2013-10-17 (first published: 2013-10-09)

6,336 reads

INTRODUCTION
Statistics contain information about the data. How the data is distributed inside the table. They are representation of a table....

2013-09-29

3,950 reads

“On the way to a grand goal, celebrate the smallest victories as if each...

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

PASS Summit East is in one week. I was on the road last week...

BCA KCP Sudirman Mansion Telpon/WA:08137887595.Sudirman Mansion, JL Jenderal Sudirman, Kav. 59 No.77 Lt. G...

BCA KCP Graha Paramita Telpon/WA:08137887595.Gdg Graha Paramita Lobby Depan, Jl. Denpasar Raya Blok D-2,...

BCA KCP Gandaria City Telpon/WA:08137887595.Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar...

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?