I agree, especially in the way of datamarts as you don't want to have to wait for shifting of data to complete. Clustered indexes have a great impact but does...

In addition the difference between index and constraint seems to be the time at which data is checked. COnstraint gets checked before insert but it does have some overhead involved....

Like I said there are alternatives and that is one. There is various things that need to be tested and I don't feel the difference between not exists and doing...

You can use sp_msforeachtable which is an undocumented proc in sql.

Do

exec sp_msforeachtable 'select * from [?] where colname = value'

will look at all tables and if they have that column...

Looks like because of

 where 

  r.ccrespid is null

Wanting I assume to know where there is no data for a particualr item in the recon table.

There all alternate ways to do...

It is clustered constraint (same as index with prechecking before insert) by default.

Try like this then

insert into dbo.recon

 select

  null,

  cct.ticket,

  null as ccr_amount,

  case when cct.trans_action = 2

   then cct.amount * -1

   else cct.amount end as trans_amount,

 ...

-- Thank you very much.

-- Now I''m getting closer.

-- So is it a preferrrable method of

-- SQL Server users authentication?

Actually that would be for Windows Authentication. That is just how...

Ok to add the power users for the local box themselves with specific abilities do like so.

1) Open Enterprise Manager and drill thru the tree view to the Secuirty->Logins for...

It is not based on the groups they are apart of outside of SQL. You can however say assign the Power Users NT Group to have access to SQL Server...

Sorry try this first if you havent already read.

This method handles the conditions for the payments table at the time of the join.

This way may significantly reduce the number...

Now that I can see what you are doing I suggest this.

I have done similar code that I have found numerous ways to write and each time something suprising happens.

I...

First off the truncate table statement will invalidate the pointer in sysindexes so the data is dropped instantly even from indexes without any rebuilding. I would suggest

Truncate Table

Drop Indexes (Even...

Not that I am aware of. Might try logging to a table or file thru package properties. That will give you a good idea.

Might want to use DMO with VBScript or a full application to get the data like you need it. Wasn't exactly sure I understood your information above thou. Was that...