SQL Server 2005 SP2 has an important enhancement to OBJECT_NAME metadata function and a new OBJECT_SCHEMA_NAME metadata function. I will first describe the old functionality to give some context and demonstrate how the new features help a lot. Please note that the examples uses DMVs that looks at metadata in each
Similar Posts
The optimizer must choose an appropriate access path to read data from each table referenced in a query. The optimizer considers many factors when deciding
Before SQL Server can perform an index seek, it must determine whether the keys of the index are suitable for evaluating a predicate in the query. Single
There are two main categories of partitioned index build Aligned (when base object and in-build index use the same partition schema) Not- Aligned (when
In my last post, I explained how SQL Server can use an index to efficiently locate rows that qualify for a predicate. When deciding whether to use an index
