--This procedure run in a DTS package

--I run this on all my tables every night and I've never had a problem with re-indexing.

--This code will only re-index the tables...

--Step 1

--if your SSNtable do not have a unique key then

Alter table SSNTable

add Unique_ID int identity

--Step 2

Select max(Unique_ID)Unique_ID,SSN into Temp_Duplicate_SSNtable

from SSNtable,

(

select count(SSN)CountSSN,SSN

from SSNtable

group by SSN

having count(SSN)> 1

)a

where a.SSN =...

or replace {}  with ()

CREATE TABLE [dbo].[tblGroups] (

 drgrpid int IDENTITY (1, 1) 

                 PRIMARY KEY  CLUSTERED ,

 drgroup varchar (100)  NOT NULL ,

 drlongcode varchar (100)  NOT NULL ,

        drattr_1 varchar (50) ...

select Colum1,Column2,

case

when Colum1 = 0 then 0

when Column2 = 0 then 0

else Colum1/Column2

end as Colum3

from SampleTable

"A Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much easier...

It depends what the data looks like in your source database, in our Warehouse I reload by checking certain fields ie Transactionnumbers or Date keys,

Declare @Tnumber...

You can check if it is necessary by running DBCC SHOWCONTIG (see BOL)

DBCC SHOWCONTIG  ('Your table name') with fast,ALL_INDEXES

- Scan Density [Best Count:Actual Count].......: 12.52% [26658:212906] must be close to...

I agree with Jamie, I use this type of set up en a daily basis for our data warehouse, I export date from more than...

If I understand you correctly:

Use the ‘Transform data task’ to insert new rows and an update query in an ‘Execute...

I’ve stopped using enterprise manager to schedule my DTS packages, just to many problems.

I use the dtsrun Utility and create a .Bat file and then execute the...