Hi David, many thanks alas the tool returns the same error I received when attempting to manually decode

Table error: DBCC PAGE page (1:8630847) (object ID 0, index ID 0, partition...

agreed 100% , but  this is something Ive inherited and the data capture was from sysprocesses and thats what Ive got to work with in this instance (-:

So as I...

• This reply was modified 1 year ago by  simon_s.

thank you much appreciated I shall have a play !

Hi Grant

yes fully understand that and my fault for not been clearer in my initial request..  I should have worded it more

" is there anyway to get all the individual...

Hi Johan

thank you for replying but that doesnt actually return the complete query plan for an object

simon

Thanks for the reply. Query store might be a double edged sword in this instance . Id need to run it in capture ALL to get accurate results and QS...

• This reply was modified 2 years, 7 months ago by  simon_s.

"There is no import mechanism that lets you load it up. You'd have to put it in separate tables. Again, you could do that. It's just going to require you...

• This reply was modified 2 years, 8 months ago by  simon_s.

I feared as much. Thank you for the advice. Much appreciated.

perhaps I haven't explained well enough. After each automation run we restore the db from backup. Thus it would effectively nuke all query store data . I want to be...

Hi Grant

thank you for your reply but thats not the behaviour I seeing . If I run this simple test I can see query store vanishes after he restore (which...

• This reply was modified 2 years, 8 months ago by  simon_s.

thank you both much appreciated

Unfortunately I dont have the space to test (create a duplicate db/table ), the whole rationale for this exercise is diskspace is full 🙁  , nor can I take it...

Field names replaced with datatypes , not unique / explicitly declared as unique

CREATE CLUSTERED INDEX [cl_table] ON [dbo].
(
[int] ASC,
[varchar10] ASC,
[dateTime] ASC
)
) 
GO

• This reply was modified 3 years ago by  simon_s.

apologies ,cut and paste error , example value 2859 i.e theyre all 4 digit numbers.

Would that be quicker do you think even with having to recreate the nonclustered (& 7...

Phil, apologies for the delay it took some working out !

The code is fine , in the real table there is a third column that only contains rows for certain...