All Tags »
Meta Data Manag... »
Data Dictionary »
Obscure T-SQL
Sorry, but there are no more tags available to filter with.
-
Ok, after putting up my first post on the Data Dictionary I had posters remorse. There is a simple change that makes the script shown in the previous post a little more user friendly. First the view metadata.columnsDataDictionary need to be changed from a SQL Select using a pivot to just a self join from the ...
-
Having a data dictionary is an invaluable resource for not only for the DBA but for anyone, report writers or developers who need to work on a database that you have to manage or have developed yourself. A good amount of time can be saved from answering the same questions over and over again if you can point to ...