SQL Server / SSMS / Expanding Columns List Query

Same as in previous post example Expanding Tables List Query I usually do not notice this type of queries working in the background. But recently I end up working with a customer having DB with 150K tables, some of the tables have more than 500 columns, and expanding columns list operation can end up being slower than usual.

Here is the code:

Query plan:

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *