Why would you want to do this?

It can be done, but you need to understand the pro's and cons to do this, and if your willing to sacrafice a little.

Do...

Edited

A single stored procedure call has an implied transaction. 

If your calling multiple then you simply have to create a begin tran, commit tran in the wrapper. Not in the individual stored...

Not exactly sure what information you mean?

are you simply trying to import data from excel to sql server?

Use the dts import wizard.

Or build a dts package.

No, Its either adventure works, or foodmart.

Both are good.

heres a quick simple little read

http://www.ciobriefings.com/whitepapers/StarSchema.asp

Make sure that all foreign key constraints referencing tableBig (Table being deleted from) are either dropped, or set to nocheck, this will speed up your delete considerably.

If your just comparing...

Try this, I posted it a while ago, I was helping a person create a crosstab query, but he also wanted it dynamic.

Reference this link when using/considering dynamic sql

http://www.sommarskog.se/dynamic_sql.html

--...

Perhaps something in the trigger is causing blocking, ultimately causing the process to terminate. Check sql logs to see if deadlocks are occuring.

you can also isolate locking in Sql profiler.

without...

Perhaps you should provide additional information about your data example.

Is the NameID supposed to correlate to some kind of hierarchy?

and how does that work?

This perhaps could end up being a...

I would try a little different approach

I would create a temp table, then copy the good 1 million rows to it. Using dts, or BCP (Using the commit 1000 rows...

Sorry if I'm mistaken, but you should be able to identify the rows that create uniqueness when you use informatica. That is what is for.

select foo, Bar

from mytable

join (select min(foo)...

Well I work for a small company with only 1 application, and we have over 30 servers.

First you have a few development servers, then a couple qa servers, for a...

When you look at the secondary database in enterprise manager does it say dbname (Read-Only)?

It could be that the initial restore of your backup was not left in recovery mode.

With Citrix all the fun is happening on the server.

I would start with running whatever process/task/report using the parameters she is supplying and evaluate the performance of that task.

It is...

Not using the From join syntax

whether its pure ansi, I'm not sure

--===== This solves the problem

 UPDATE #yourtable

    SET IRD = 1

where exists (select *

              from (select FT, Doc, min([Date]) AS...