Actually we have 1000 or more procs and it is not an easy task to debug all and find out where person has not used proper coding guidelines

I was thinking...

Thanks

You can try this

create table dbo.emp(EmpId int,DOB datetime,City varchar(30),Gender char(1))

insert into dbo.emp(empid,DOB,City,Gender)

select 12335,'1jan2014','Gurgaon','M'

union all

select 23456,'10jan2014','Gurgaon','M'

union all

select 23456,'1jan2014','Gurgaon','M'

union all

select 545432,'1jan2014','Gurgaon','M'

union all

select 231245,'1jan2014','Gurgaon','M'

union all

select 231245,'12jan2014','Gurgaon','M'

with cte as

(

select distinct a.Empid

from dbo.emp a...

Thanks all. It was nice discussion.

I had few gaps on my knowledge which i have filled after this discussion. If you get time, please read below article, it has...

I agree with you Koen.. it depends on your requirement and interest.

🙂

http://msdn.microsoft.com/en-us/library/ms141031.aspx

Yes you can do but i would suggest to test these options before you think for other

1.Pushing data into an indexed table will take much more time than pushing the...

Are you testing me ...?

Limitation

1.Identity:- It's table dependent, you can apply identity on single table at a time. It is not a separate database object like Sequence.

Identity column is specific...

I misread the question.I thought he is asking alternate of identity so I suggested Sequence because performance wise, Sequence is better than Identity and we don’t have limitation in sequence...

i would suggest to use Sequence in place of identity

You can use package variable and that variable value you can use to update your table according to you email sent or not

I don’t think so because RetainSameConnection = TRUE to control flow of an SSIS package threads together various control tasks. It sets a transaction that can span into multiple...

I think overwrite or deleting existing file from source folder could be an issue. After loading data into staging table, you can move those file into Archive folder in place...

Can we use like that..

if it helps

declare @Lkd int;

Declare @Tho int;

Declare @Hun int;

declare @num decimal;

set @num=1055263.55;

set @Lkd=@num/100000

set @tho=((@num%100000)/100)

Will it help

SELECT

[procedure] = QUOTENAME(OBJECT_SCHEMA_NAME([object_id]))

+ '.' + QUOTENAME(OBJECT_NAME([object_id])),

last_execution_time,

avg_execution_time =...