Technical Article

Function to Return the Amount of Children in a Tree

Assuming we have the following table (that stores hierarchical data)  :CREATE TABLE [staff] (    [employee] [int] NOT NULL ,    [employee_name] [varchar] (10) NULL ,    [supervisor] [int] NULL ,     PRIMARY KEY  CLUSTERED     (        [employee]    )  ON [PRIMARY] ,     FOREIGN KEY     (        [supervisor]    ) REFERENCES [staff] (        [employee]    ))I ‘ll built a […]

You rated this post out of 5. Change rating

2002-08-23

827 reads

Technical Article

Alert When Not Enough Free Disk Space

--Implement an Alert Which Trigger when Specified Disks--free space exceeds a specified alert level--Steps to implement:--1) Define a Custom Error Message with messsage text (The ---drive free space is bellow alert level. Details: %s)--2) Define an Alert linked to CEM defined at step 1--3) Implement a Job which execute the following step in a recurring […]

You rated this post out of 5. Change rating

2002-06-04

2,684 reads

Blogs

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs

Forums

Help with a SQL Unpivot

By rogue1009

I am trying to use unpivot to extract some data, however, the results are...

how to de escalte a isolation level, and are there any implications.

By rajemessage 14195

hi, I have one nested transaction and want to deescalate to outer  transaction's isolation/...

Scaling Up Monitoring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Scaling Up Monitoring

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers