SQLServerCentral Article

Eliminating Cursors

T-SQL does some things wonderfully, but cursors are the bane of the language, often causing performance issues. Changing your queries around to remove cursors can be tricky and new author Kamran Ali brings us one technique he has used to dramatically improve performance.

Blogs

Programmatically Retrieving MLV Lineage and Refresh Times

By

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

SWAG Saves the Day

By

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

Upgrading SQL Server Containers on the Laptop

By

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

Read the latest Blogs

Forums

BCA KCP Green Ville Telpon/WA:08218168291

By Simpson 64488

BCA KCP Green Ville Telpon/WA:08218168291.Jl. Ratu Kemuning, Jl. Komp. Green Ville Bl. Bd No.5...

BCA KCP Utama Raya Tlpn/wa:085373737551

By theunique1011

Jl. Sumur Bor No.29 B-C, Cengkareng Bar., Kecamatan Cengkareng, Kota Jakarta Barat, Daerah Khusus...

BCA KCP ITC Roxi Mas. Tlp:085373737845

By Simpson 64488

BCA KCP ITC Roxi Mas. ITC ROXY MAS, Jl. Kh Hasyim Ashari No.125 Basement...

Visit the forum

Question of the Day

Increase Deadlock Detection

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

See possible answers