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 […]


182 reads


Updates from Coping Tips


I’ve written a lot of coping tips now. Over two years worth (Mon-Fri) since...

What I’ve learned in my first 100 days with a consulting group


In case you don’t follow me on LinkedIn or Twitter, your humble host joined...

Power BI as a enterprise data warehouse solution?


With Power BI continuing to get many great new features, including the latest in...

Read the latest Blogs


How To Flatten JSON Data?

By Chris Wooding

I receive data in JSON files and for one particular type of data I...

Last Cube Refresh Showing Wrong Time

By Shivs

Hi I have a tabular model and have been asked to retrieve the last...

Working with T-SQL function AVG ()

By Manvendra Deo Singh

Comments posted to this topic are about the item Working with T-SQL function AVG...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers