Thanks Guys

The file being read contains Receipt Header with it corresponding lines just after the Receipt Raw header

The file includes several Receipts

So Maintianing the read order is very...

Here Are sample Code

Stores Is a small Table Less Then 1000 Rows and less then 300 bytes per row

======================================================

--Drop the session if it exists.

IF EXISTS (SELECT * FROM sys.server_event_sessions...

Thanks for the advices

1. The Recovery model is simple in the first place

2. Restarting the instance is risky and in this situation the worst result might be suspected database.

...

well i have Installed Case Insensitive Instance on my machine

The paramter declareatiom is infulanced by the server collation

Case Insensitive Server Collation :

Declare @Col1 int

Set @col1 =16 ...

Thanks

My Conclusion from you answer is that if I don't have to keep the transaction log backups that occurred since the transaction stared and prior to the full...

Thanks for every body

1. Right now it is a theoretical question on wat is the best practice

2. I sugested the insted of trigger just to be able to...

What I had In Mind Is to Create Temporary Tables for deleted and inserted and than create an Index on them for the fields Key and sex ,then Log...

So what can be done to boost trigger performance on a large scale update

Does Instead of trigger with cte or temporary table is beter and in the use an update...

Thanks for the answer but , this information was almost obvious to me

My real Concern is performance

Do I Need to create indexes on the base table in order...

I know hat set based thinking is beter for SQL Server

Each records holds the key for a data collecting operation which involves very complicated comutation

these computations can not be...

MAX DEGREE OF PRALELISEM Will not work here

Because the stored procedure that is beeing called works on create a pool of recrods and then process them one at a...

Yes you are right I ment CLR

The reason is that Ihave a batch processing which varies

between several handred records to oprocess to several milions of records

I wand...

thanks for the query

but still it i am not getting the result I want

the NT Login Name and and NT Domian ARE empty for sql Server Logins

Thanks

It is not likely to give all developer on server a sysadm even in the development evnironment

a specialy on hilghy data driven debug.

Thanks

I have Checked wth other sources and they said the same

Configuring the sql to use will be done shortly