SQLAndy

This was fun to run through, nice to see MS adding features even if in my view they didn't quite...

2007-06-12

1,327 reads

Clustered Index Seek or Key Lookup

When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...

2007-06-04

1,760 reads

I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...

2007-05-29

1,362 reads

I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.

2007-05-23

1,425 reads

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

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

WhatsApp 083110611866Jalan Marsma R. Iswahyudi 05, Rukun Tetangga No.20, Kota Balikpapan, Kalimantan Timur 76115

WhatsApp 08388331767 Jl. S. Supriadi No.65, Sukun, Kec. Sukun, Kota Malang, Jawa Timur 65117

WhatsApp 0831•7943•7466 Jl. Gunungsari No.5-7 blok G, Sawunggaling, Kec. Wonokromo, Surabaya, Jawa Timur 60241

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