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


183 reads


Quick Filtering in SSMS–#SQLNewBlogger


I saw someone limit the databases they see in SSMS, which isn’t something I...

Penetration Testing your SQL Server, Part 1 – The Recon Mission


Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking...

SQL Saturday Denver 2023–VCS Primer for the Database slides


My slides are here: VCS Primer Denver 2023 This was an overview of what...

Read the latest Blogs


High tempdb usage alternatives

By anoop.mig29

Hi We have an stored procedure which runs frequently and  it contain logic in...

high latency in sql server transactional replication

By anoop.mig29

Hi I am new to replication and we have database of size around 2TB...

get week number of month

By GrassHopper

I want to query a table that has a datetime column ([CreateDateTime])  and get...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers