Extended Properties Introduction

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Adam Aspin » Extended Properties Introduction

40 posts, Page 4 of 4

«««1 2 3 4

Extended Properties Introduction

Rate Topic

Display Mode

Topic Options

Author

Message

Vedran Kesegic

Posted Thursday, March 17, 2011 5:24 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 343, Visits: 1,089

I heard (from a person closest to the author) that in one of the next releases of XDetails plugin for Sql Management Studio it will be possible to easily edit column comments. It will be editing in-line in grid that displays descriptions near the table columns' names and types.

_____________________________________________________
XDetails Addin - for SQL Developers and DBA
blog.sqlxdetails.com - Transaction log myths - debunked!

Post #1080119

Jeff Moden

Posted Thursday, March 17, 2011 10:08 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 9:01 PM
Points: 33,111, Visits: 27,037

Adam Aspin (3/17/2011)

Thanks Jeff - praise from a leading light like yourself makes my day!
There are three more articles to come (one a week for 3 weeks) which, hopefully, will help newbies not only add, but also extract and update this metadata in a comprehensive manner.
Adam

I saw that in your intro and I'm very much looking forward to them.

And, thank you for the very kind words. Blush

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1080140

Patrick2525

Posted Friday, March 18, 2011 8:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 01, 2013 10:16 AM
Points: 117, Visits: 180

ACinKC (3/17/2011)

I created an Excel/VBA solution for my current gig that read in the metadata for the tables and columns into a workbook (one worksheet per table) [...] It's a two-way tool, creating the Data Dictionary (in Excel) from the database and using the same tool in turn to update the EP values in the database.

Sounds interesting... is that something you can share? Smile

Post #1080412

JediSQL

Posted Saturday, March 19, 2011 11:06 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:18 PM
Points: 27, Visits: 102

This regards the use of the MS_ prefix. SQL Server Management Studio and the third party "SQL Documentation" tools I have demoed use the MS_Description as the name/property that they display. So I have set up our extended property system to use MS_Description for our general description comments. That way, someone using SQL Server Management Studio or one of the third party tools will get our main description comment. But it is good to know that Microsoft uses other MS_* names/properties and, in general, the MS_ prefix should be avoided.

I went with Microsoft's lead on using MS_ as a prefix to set up a name space, so I have our team using our own prefix, CSIT_ (CureSearch Information Technology).

In our industry, cancer research, the NCI (National Cancer Institute) is essentially requiring all of its grantees to use its ISO-11179 meta data repository. Once you get used to it, it's pretty cool. We are setting it up so that all our columns, etc., will be assigned data element descriptions, and the assigning of data elements to columns will automatically update the MS_Description property for casual inspection.

Sincerely,
Daniel

Post #1080860

JediSQL

Posted Saturday, March 19, 2011 11:14 AM

SSC Rookie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:18 PM
Points: 27, Visits: 102

This regards indexed views. Indexed views are available in standard edition. What is limited to the enterprise/developer edition with regards to indexed views is the query optimizer's use of indexed views to enhance performance of queries that do not explicitly reference an indexed view, but there is an indexed view that has some of the joins already computed.

Sincerely,
Daniel

Post #1080863

aigl

Posted Monday, March 21, 2011 10:35 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 29, 2013 8:44 PM
Points: 1, Visits: 7

I see great use of the Extended Properties if you can make use of them as tool tips in Reporting Services. Hopefully one of the future topics will cover that.

Is it possible for View columns to inherit the Extended Properties from the Table columns that the View is based on?

Post #1081735

Adam Aspin

Posted Tuesday, March 22, 2011 2:18 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:26 AM
Points: 81, Visits: 857

Hi Danjam,
You are, of course, quite right about indexed views and standard version - thanks for correcting this.
Adam

Post #1081785

Adam Aspin

Posted Tuesday, March 22, 2011 2:20 AM

SSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 10:26 AM
Points: 81, Visits: 857

Hi Aigl,
I have never used extended properties in reporting services, so please share the knowledge if you get this working.
Also, as far as I know, you have to specify column view properties per view (or write the code to extract and attribute them) and there is no simple inheritance.
Regards,
Adam

Post #1081786

Cade Roux

Posted Tuesday, March 22, 2011 2:16 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, January 23, 2013 9:10 PM
Points: 105, Visits: 481

aigl (3/21/2011)Is it possible for View columns to inherit the Extended Properties from the Table columns that the View is based on?

I don't think so, and I wasn't even able to apply extended properties to columns of views (although I was able to apply them to views themselves)

However, I see in this latest article, Adam has a query which is supposed to expose them, so I'm going to go revisit that.

Post #1082334

Yitzchok Lavi

Posted Tuesday, September 04, 2012 10:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 10, 2013 9:49 AM
Points: 2, Visits: 129

Has anyone found documentation of the Extended Properties available in SQL Server 2012 to parallel that for 2005-2008R2 which is available at http://msdn.microsoft.com/en-us/library/ms190243.aspx??

Post #1354026

« Prev Topic | Next Topic »

40 posts, Page 4 of 4

«««1 2 3 4

Permissions