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
823 reads
2002-06-06
468 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,646 reads
By Steve Bolton …………In the last two installments of this series of amateur self-tutorials...
This year PASS is trying something new at PASS Summit. There are going to...
One of the most significant and hardest challenges we face as data professionals (or...
I have a table "Mytable" containing a list of IDs. There is a web...
So I have a DW with a table with some pre-aggregated scores (not my...
HI all, About to start this project and would be grateful for any good...
Ask SSC