Parsing Parameters in a Stored Procedure
This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure.
2012-11-02 (first published: 2010-08-10)
29,765 reads
Blogs
When Read Committed Snapshot Goes Bad – Version Store Filling TempDB
We all had those calls, it’s the middle of the night and we get...
Daily Coping 17 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Finding a common AD group for a set of users.
A while back (almost 7 years ??) I wrote a post on finding the...
Forums
UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue
I've been working a little bit with a few tables here, they've got "CreatedDate"...
Multiple deadlocks occuring on simultaneous deletions from temporal table
We have a stored procedure which is attempting to delete 1-2 rows at a...
Foreign key for Xml Datatype
Is foreign key constraint possible in xml data type? OR Is it possible to...
Ask SSC