That's great to know. Thank you!

Thank you. Yes it was in there. I'm not sure how I missed it the first time. I did a simple search for the word might in...

I thought I answered Paul's first question. If we use the binary string, it would need to start out with ~20K bits. This is because the settings would...

All 20K bits would be in the string if a binary solution was chosen, because the position in the string would be the identifier of the particular setting.

It's...

Yeah, that's essentially what I'm doing, except I'm doing the deletes as a set. Well seems like I've got a good solution.

Thank you for your feedback!

No, I don't have it in a CTE, but I will go back and look at refactoring the delete procedure to do it as such, that would be good.

Thanks!

I can try turning off the cache to see if the problem goes away. but I am not getting the error mentioned above -->

"Error 830 Severity 10

stale page...

...the SQL Account has administrator priv., so yes I would believe it can lock pages in memory.

.. and Rob, I would agree with you that the 2nd process...

I've attempted to attach to the post a snapshot of a report generated from our SAN containing Configuration information.

I appreciate your time!

Thank you very much.

Thank you. Yes, you have the logic correct. And I share your thoughts on this. However, my colleague seems to think that because the SAN has two...