Splitting a string by a delimiter in SQL Server involves breaking a single text string into smaller parts based on a chosen character. This is often done using functions like STRING_SPLIT, which ...

A Technical Project Manager with expertise in agile methodologies, project planning, quality assurance, and more. SQL (Structured Query Language) is the universal language for managing and interacting ...

Description: Script is creating objects for monitoring of replication subscriptions health state. Very simple solution for sending you emails when some subsciption is not running or containing warning ...

WHEN CHARINDEX('Memory Manager', object_name) > 0 THEN 'Memory Manager' WHEN CHARINDEX('Buffer Manager', object_name) > 0 THEN 'Buffer Manager' WHEN CHARINDEX('Plan ...