SQLYSE with Pankaj Manek

In my previous post, I mentioned the use of functions, specifically ISNULL and the effects on SARGability of the query....

2015-09-07

1,296 reads

ISNULL around the predicate and SARGability

You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...

2015-08-20

3,772 reads

Time and again I see developers querying SQL Server trying to retrieve TOP (N) records but without using ORDER BY,...

2015-07-31

10,498 reads

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...

I don’t have SQL Server installed on my laptop. In an effort to keep...

MENARA BCA d/a GRAND INDONESIA, Tlp:085373737845.Jl. MH Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...

Jl. Gajah Mada No.112 B-C-D, RT.1/RW.1, Krukut, Kec. Taman Sari, Kota Jakarta Barat, Daerah...

Jl. Cengkeh 21-21A, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat, Daerah Khusus Ibukota Jakarta...

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