Discussion:
Query Performance on Tables with Column Descriptions?
(too old to reply)
Jarppi du Plessis
2014-01-23 08:02:46 UTC
Permalink
Hi All
Someone just told me that query performance is degraded when columns contains descriptions in table definition, since SQL reads everything, every time!

Is this true?

Jarppi
Erland Sommarskog
2014-01-23 08:12:14 UTC
Permalink
Post by Jarppi du Plessis
Someone just told me that query performance is degraded when columns
contains descriptions in table definition, since SQL reads everything,
every time!
"descriptions in table definition" = extended properties?

No, that is false.
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Loading...