You're missing things alright.

begin transaction tl

delete from table

commit transaction tl

At this point the only way of getting back to the database state BEFORE the delete was executed, is to go...

Aha...well that bit (an account can play more than one role for a fund) was left out of the description.

But it may also point to a need to go down...

"1. Funds

Fund_ID int PK

Fund_Number varchar(10)

2. Accounts

Acct_ID int PK

Account_Number

3. FundsAccounts

FundsAccounts_ID int PK

Fund_ID int

Acct_ID int

Role_Description varchar(20)"

I have to query/challenge your starting presumption of automatically using a 'generated' key for the primary keys.  Each table should...

"But by tlog information in BOL microsoft says that we can recover any transaction from tlog."

You can recover info using the TLOG...PROVIDED it's STILL in the TLOG.  The TLOG is...

The most consistant advice I've seen re images is to keep them out of SQL Server altogether...just use references to the physical files stored on a LAN/SAN.

"Ban Canadians".....

my my ....somebody doesn't like the 51st state (what crappy beer did the some barperson give you?....or are you jealous of the view of Niagara Falls from the northern...

Why not just take 10 random characters out of a call invoking NEWID().......

The delay is possibly related to the size of the single transaction into tablec.

Can this process be broken into smaller sub-steps with smaller commit points, where each successive execution, loads...

Couple of things.

a) Do the clustered indices help support user queries, or "are they just there...because of a historical decision"...because if the data is not being loaded in a manner...

beware

"SELECT SCRCTG, * FROM tblIntelecDownload WHERE ISNUMERIC(SCRCTG) = 0"

won't deal with some 'char' data...ie numbers which can be represented using "scientific notation" ....particularly D and E

SOX is about seperation of duties and the creation of procedures to monitor and control same.  Once you have a procedure in place to cover the 'viewing/usage' of an 'SA'...

You'll waste the full benefit of that budget IF you put the Web server on the same machine as the SQL server.  2 memory hogs don't live well in the...

Application server....  ".Net"?...advice seen elsewhere is "not to run SQL server and IIS on the same server".

Presume you have "Profiled" the SQL code + DB to ensure you have optimal...

Red-gate.com have a net based bug-tracking application (hosted and  inhouse versions or so I read)....they also produce the SQL Compare product.

In effect your query is one of the type "give me every record or give me some records".  However the Plan must deal with both situations....and a "give me every...