Thanks.

Any one has a script. Thinking of something that will read the object definitions and map the relations. Please let me know.

Grant Fritchey (9/30/2010)

---

I won't try to dissect the paging stuff. There are smarter guys than I am around here who can do that. But, I will point this out:

Where ...

My exact thinking. What causes a table lock? how PROC1 which is issung BEGIN TRAN can...

While I am going thru the article, my question is why the PROC2 beging blcoked from even running the query. It was just waiting for PROC1 to issue commit. I...

. It might come down to checking the execution plan for this query... the query and/or indexes might need tweaking, and this could be causing the query to take this...

GSquared:

Thanks

No my company does not allow. Also it is too hard for...

Thanks Jason.

I will check with the network folks. But before going to them, is there a way from the application perspective that I can prove to see if there is...

Thanks for the input.

OK. I have posted the solution in post #4. But reproducing here.

---------------------

Script to create tables

---------------------

USE [AdventureWorks]

GO

/****** Object: Table [dbo].[myparent] Script Date: 12/03/2009 15:10:53 ******/

SET ANSI_NULLS ON

GO

SET...

Sure. I have posted the sample code at http://www.sqlservercentral.com/Forums/Topic827863-21-1.aspx. I could as well post it here, but why to waste storage?

OK. I stand corrected.

I have created the test script based on my original script, simple but follows the same logic.

---------------------

Script to create tables

---------------------

USE [AdventureWorks]

GO...

Not sure if the above question was confusing. Please let me know if it needs further explanation.

When I said "flat" I meant from the "relational structure" point of view. For example you have a Parent and two children, then you can represent this by

parent1,...

Mauve:

Thanks for the response.

Just to eloborate on my requirement. My XML/XSD would follow the following format

-------------

<message>

<message header>

<messsage ID>

<date time >

< etc etc>

</message...