2
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Mastering The Metadata: Part 1 (Tables #1)

published 749 days, 15 hours, 24 minutes ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 755 days, 21 hours, 41 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 4:39:51 PM GMT

In this post, I’m going to outline the core metadata SQL Server 2008 uses for Tables, and how you might be able to use this metadata in a useful manner.  In this post, I’ll only go as far as outlining the potential for using table metadata to discover storage characteristics of the table.  I’ll provide more detailed examples in my next post of how you can put this to work.  Before we begin, a brief history lesson to do some context setting.

Once upon a time in the distant past, a relational database...

category: Query | clicked: 5 | | source: ozziemedessql.blogspot.com | show counter code
tags: Metadata, MSSQL, SQL Server 2008, System Catalog, T-sql

No comments yet, be the first one to post comment.

To post your comment please login or signup