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 […]
2002-08-23
824 reads
2002-06-06
470 reads
--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 […]
2002-06-04
2,653 reads
Query tuning is not easy. In fact, for a lot of people, you shouldn’t...
This year I’ve been nominated again for the Author of the Year award at...
I know, I know, I’m on #teamexevents so I think that Extended Events can...
Hi Is anyone know please advice, how much time will take for restoration 250GB...
problem how to create query based on optional field on temp table ? I...
problem how to create query based on optional field on temp table ? I...
Ask SSC