Here is an example that demonstrates what I said above:

CREATE SYNONYM [dbo].[SomeBigTable]

FOR [dbo].[<Insert Your Table Name Here>]

GO

DBCC FREEPROCCACHE

DBCC DROPCLEANBUFFERS

set statistics TIME ON

set statistics IO ON

GO

print '==== 0...

The difference between Logical Reads and Physical Reads is essentially one of Caching & Batching. There is a lot more detail to it in terms of Microsoft's specific terminology...

Cool. That would be my choice, simpler.

This online article from the Microsoft documentation Books Online (BOL), explains it better than I ever could: http://msdn.microsoft.com/en-us/library/ms191300(SQL.90).aspx

Paul: So on RollBacks, will it leave permanent gaps, try to recycle the gaps, or does it guarantee no gaps, ever? (I am pretty sure that this last...

To the best of my knowledge, you cannot do anything like that in SQL Server as it does not allow you to alter, modify or in any way change its...

Umm? Something seems missing here. You've given us a DTD, what do you want us to do with it?

(ps., an XSD would probably be easier)

Thanks for letting us know the solution, Apijena.

One suggestion: something that I learned from Paul White, is that explicitly using the "/text()" function for queries like these can have a...

Welsh, et. al.:

I have been out the last day or so, and I sure am sorry that I missed this golden opportunity for self-promotion (:-)), as I have actually written...

exactly...:smooooth:

Paul White (2/27/2010)

---

That was based on Jeff's code I think....

agustingarzon (2/27/2010)

---

Barry:

I'm posting a different plan, the one for the query suggested by Jeff.

What I meant originally is that it takes a lot to retrieve at the position 30.000, but...

Capture the actual query plans for both the bad one (30000) and the good one (31000), save them as *.sqlplans, zip them up and post them here as an attachment.

Matt Miller already covered batching with the OP on the first page. The OP is looking into it.

Jeff Moden (2/26/2010)

---

Welsh Corgi (2/26/2010)

---

I agree with the distinguished Forum Members with respect to the use of Dynamic SQL.

There are many reasons to avoid this. If you want...