onetsql,

Nice link.  Thanks.

I'll likely never make the attempt on these forums because it's not permanent to this forum.  If it goes away, any answer...

Created a table in such a way, each rowsize is one 8K page.

Now when I execute this

SELECT T.name as 'Table', ix.index_id, ix.[name] AS IndexName, ix.type_desc AS IndexType, [ips].[index_level],...

So what was your final problem and resolution?

Hi Jeff

Yeah vendor is aware of this issue. But get where you are coming from for sure.It was caused by a crappy import tool they wrote.. Really the records...

I seriously wish you the best of luck.  Get your QA/UAT started on checking for bad info/reporting/etc.

Personally, it was the DB Vendor's code that allowed the "duplicate" to begin with and I'd ask them rather than changing data that may have a substantial impact somewhere else. ...

It can't... there's no ORDER_ID column in...

It can't... there's no ORDER_ID column in the Vendor...

You are correct.  Each 7000 byte + the ID row occupies 1 page.

On my box, I'm always getting 2 reads more than the number of leaf level pages regardless of...

It'll be interesting to see what kind of Execution Plan is built from all that.  The use of DISTINCT also suggests that you may have at least 1 many-to-many return...

In the following, you have an underscore in the code that does not exist in the TBL_Vendor table.

on vnd.ORDER_ID = ord.ID

Lordy.  My apologies.  I didn't look at the "record layout" for sys.dm_tran_active_transactions (from your query you posted)...  The bloody database_transaction_begin_time column in that DMV is returned, by the system, as...

That's the main reason I really liked the question.  I've run into a whole lot of...

@Sridevi kakolu,

Thanks for the reply and the referenced material . I was worked with this option for many PTO tasks, but what I am looking for is , a...