It's stored in the registry, so you could query that... not a great option.

I'm not so much worried about the FK's. How do I get the data out of the structure you have defined?

I ran a test. I saw two StmtCompleted events for a proc that called sp_executesql. What I saw was a preperation statement and an execution statement. I suspect you'll see...

StmtCompleted is pretty expensive to the system. You'd be better off collecting RPC:Completed and SQL:BatchCompleted. Those two are more or less equal. StmtCompleted are the individual statements within a batch...

pat (12/5/2008)

---

sorry to make it confusion on the query:

Tables:

Person : emp_id, org_id,mgr_id,loc_id

manger : Mgr_id, Name

Location : Loc_id, disc

Organization : org_id, disc

so now the question is :

org_id for all empid belong...

I agree with everything Michael posted.

The one point I'm not sure about... From your description, does this report even use a WHERE clause when accessing the information for display? Does...

Speaking generally, it really sounds like you're on the right track using partitioning. Andy Novick (MVP, consultant, nice guy) has presented at PASS and our local users group on using...

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...