Please do as Gail requested in order to get detailed help, but I will point out these two phrases in your post:

debjani.bedajana (12/4/2008)

---

In my database , I am storing millions...

pat (12/4/2008)

---

Hi all,

I am trying to update location for employee organization:

any employee that has organization field updates to the data that’s in their managers organization field

i have query but...

You should be getting a return code from the procedure when it's called initially. Normally, unless you mess with it, it's 0 for success and any other value for failure....

Prior to 2005, people (including me) tried using OPENXML to perform this function. It worked reasonably well, but instantiating the XML document back then was a pretty major performance hit,...

Yeah, from this script alone, they...

It's 4,5,and 6 that we're going for, paying for them with 1,2 and 3 and the other things already mentioned on this thread because, after all, TANSTAAFL.

Just a wrinkle on top of what you're doing, get individual scripts for each object, not one script for the entire database. It's more difficult to work with individual objects...

Tempdb is the biggest cauion in the lot. You have to know that if the tempdb fills while dealing with READ COMMITTED SNAPSHOT, then the read's against the data aren't...

meichner (12/4/2008)

---

I am a C# program (.net 2.0) using Sql Server 2005. I would love nothing more then to do all of my transaction processing in T-SQL. ...

I'm not aware of any differences in behavior on READ COMMITTED SNAPSHOT. They did introduce the SNAPSHOT isolation level though. It's much more stringent and requires actual code changes to...

I might be off on this, but did you try this;

INSERT INTO xTable ( xCol )

VALUES ( @xmlEvents)

I wish I knew.

You can look at the date that the statistics were last updated. If it seems to long ago (very scientific) then you can update it. You've got...

You can't put them both within the same IF clause? It's pretty simple really, if one can evaluate and the other can't, you're going to arrive at a logical error....

Hey Barry,

Yeah, the GDR got released last Tuesday. FINALLY. And yeah, DBPro & Visual Studio Team System Database Edition are the same things.

That's a good idea. I'm in the middle...

ritesh.saluja (12/4/2008)

---

I want to import large data in one table from csv file.

When the performance of import would be better.

1. When I remove the index in the table and then...