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
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,653 reads
I’m a creature of habit. I have my routine when I get to my...
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
By Vinay Thakur
Today was working on SQL Server cursor standard cursor deification would be like this:...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Hi, Application service is going to hung state and when we check the database,...
Hi, Does blocking has affect on High DTU utilization ? (some people advocate that...
Ask SSC