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

202 reads

Blogs

Day of Data Baton Rouge Slides and Code

By

Thanks to everyone for attending my talk today at Day of data Baton Rouge...

Using Claude Code as a Database SRE Agent with the Everpure Fusion MCP Server

By

Here’s the scenario: one of my SQL Server instances migrated to the DR array....

The Book of Redgate: Products

By

We are product focused at Redgate Software. Here is another of our values that...

Read the latest Blogs

Forums

The SQL Server 2016 Plan

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Server 2016 Plan

whats that ssis analyzer product that documents lineage

By stan

hi, a few years ago was at a very large company that bought a...

Implicit Conversions Cripple SQL Server

By sabyda

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)
What is returned?

See possible answers