Dinesh Priyankara

  • Interests: MS SQL Server, c#.net

Technical Article

Delete record efficiently. (sp_CheckAndDelete )

The sp_CheckAndDelete stored procedure specially created for handling process of data deleting efficiently in MS SQL Server 2000 tables, as it is too difficult to handle this process when dependants exist for record to be deleted. When the deleting process is done with sp_CheckAndDelete stored procedure, you will be informed the status of the process […]

You rated this post out of 5. Change rating

2003-01-30

195 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

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

Advice I Like: Celebrate Success

By

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

Programmatically Retrieving MLV Lineage and Refresh Times

By

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

Read the latest Blogs

Forums

BCA KCP Kebon Jeruk,Telpon/Wa 0821-8200-239

By crowdfundingsoftware

Komp, Jl. Taman Kb. Jeruk Jl. Meruya Ilir Raya No.Blok B 6, RT.1/RW.9, Srengseng,...

BCA KCP Tmn. Harapan Indah,Telpon/Wa 0821-8200-239

By crowdfundingsoftware

Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru, Daerah Khusus Ibukota Jakarta 11460

BCA KCP Kepa Duri,Telpon/Wa 0821-8200-239

By crowdfundingsoftware

Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat, Daerah Khusus...

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