Be Cool! You can trust on SQL Server Identity column. It will not give you duplicates.

Do not Insert data with IDENTITY_INSERT ON option. Then SQL Server take care of concurrency, it is guranteed that there will not be any duplicate id in Identity column.

What I understood you need conceptually is a dynamic array of varchar(20) as a input parameter of a stored procedure. You can achieve this in SQL Server 2008 using the...

The Update statement you have used is just incrementing the column value by 1 which does not make them unique.

Can you please explain your requirement in details. You can...

One easy logical way you can try .. I am not sure this is the best way or not..

SELECT CONVERT(DATETIME,(CAST(YEAR(GETDATE()) AS VARCHAR) + '-' + CAST(MONTH(GETDATE()) AS VARCHAR) +...

thanks a lot for your valuable guidence.

sp_updatestats has any locking ipmact on the the table during the execution of the command. Can we run it for few tables only instad...

Hi Gail,

you have mentioned the non updation of statistics is an expected behaviour for this case as the data insert volume not yet reached 20% till last statistics update. But...

I have also faced similar problem and for me there is no maintenance plan / shrink db done.

the DB was in SQL2K5 express edition and the recovery model is Simple....

thanks a lot for the info.

The table has almost 10 mn records and for today only 100K has added so as per the default threshhold the behaviour is fine.

But...

It is on SQL Server 2008 with Compatibility level 90

Thanks for your suggestion . I know I can get performance enhancement if the tempdb is on a seperate physical hard disc.

My main concern is what impact could hsve (if...

If you are using SQL Server 2005 then you can try SSIS with Data Flow Task. Define Set Rows Per Batch & Maximum Insert Commit Size under OLE DB Destination...

I hope client can have some business need for keeping the employee id as e.g. EBRD02, EBRD04. In that only the numeric id can be generated by identity...

Uniqueidentifier stores GUID value which is unique through out the globe can be inserted by NEWID(). One of the purpose of using uniqueidentifier as PK as per my persional experience...

Thanks everybody ..

It worked . It will really help me..:)

Thanks once again..