You mean the complete backup and restore the Db on another (offload, Dev) server ?

You mean to completely restore backups on an off-load server ? (Dev.. )

How exactly is it done? I mean, exporting the existing cache to another system ? (I have not found anything on www on that..).

Your help will be really appreciated...

Well, this is exactly why I am looking to find out what SQL (and preferrably Calling_Object_Name (SP or FN...) that is associated with each missing indexes, so that we look...

That's exactly what my final goal is, to find either SQL or better SP or FN names that would benefit from each missing index.

Also, a certain % of queries will...

yes. attached. sql works fine. it s a challenge how to format the flat file right..

that's exactly right. I do not want comma delimited.

but the output (DESIRED one) that you see on the top of the first page of the attachment is correct, there...

Whatever I do, the columns in text file do not come out justified and separated by equal space, with column name precisely on top of column data (which doesn't happen...

The reason i asked about that was because there are a couple of folks who i work with who specifically asked me if I know a SQL Coach who could...

you mean you actually are not doing SQL/databases/programming for living?!

how can that be...

Thank you !!! You are the man.

I really appreciate your help.

Question:

are you actually really coaching some dumber folks like myself in SQL server remotely (I mean for pay)...

full table data is also in XL (spreadsheet 2).

What you mentioned is very cool. We do not have Identity id column gaps (yet..),

while they are indeed possible.

Thus my next question :

How come that the result-set from this...

it was very helpful! thank you!

<< I wonder if there is anyway whatsoever to distinguish these dupes from each other.>> well it is NOT KNOWN.

IT will take a while till we complete the study...