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

Browse by Tags

All Tags » Meta Data Management   (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, May 16, 2008 5:45 PM

Ordering SSIS packages in Visual Studio 2005

Problem: SSIS Packages in Microsoft Visual Studio 2005 are ordered in the order of package creation by default, or more precisely the order they have been added to that solutions/projects folder. What this means is that if you have an SSIS project that
Posted by steve | 0 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