Welcome to VSTSC's Community Server Sign in | Join | Help

Browse by Tags

All Tags » Meta Data Manag... » Obscure T-SQL   (RSS)
Tuesday, July 08, 2008 5:07 AM

space_used_sp vs. sp_spaceUsed

Ok I'm not one to re-write standard system stored procedures for SQL Server. That being said I have been working a good deal with files and file groups within SQL Server over the past few days moving data and indexes to files and file groups other than
Posted by steve | 2 Comments
Friday, January 25, 2008 10:26 AM

Data Dictionary Part II

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
Posted by steve | 0 Comments
Attachment(s): DataDictionary.sql.txt
Tuesday, January 15, 2008 10:26 AM

Data Dictionary part I

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
Posted by steve | 0 Comments