Umm, not sure how to approach this. I read the article, but was confused in a few places. Some of this is due to the fact that I really don't know what the SQL Server Query Data Store is, but also part of it is, well I think something got past the editor. For example, the first paragraph ends with:
We were excited by the chance to actually gather some information on the .
On the what?
Then in the fourth paragraph, it starts by saying:
I don't expect that a lot of improvement at SQLServerCentral from changing this, as our third party forums and much of the internal code is batch SQL, and quite a bit generated on the fly. However, there are some stored procedures, and I might be very wrong.
I'm sorry, but I'm not following you here. So, you've got some stored procedures and how might that make you wrong? I'm probably being obtuse in my understanding, so please bear with me and help me by clearing up these two things. Thank you.
Kindest Regards, Rod Connect with me on LinkedIn.