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

Browse by Tags

All Tags » Obscure T-SQL   (RSS)
Monday, November 03, 2008 9:52 AM

SSIS Execute SQL Task and RaisError (Using a OLEDB Connection)

This is a relatively short post about raising an error in T-SQL and having SSIS not recognize that error. If you have an SSIS package that calls a SQL Task and that T-SQL for whatever reason ends up raising an error the SSIS package that called the T-SQL
Posted by steve | 0 Comments
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
Friday, January 04, 2008 10:18 AM

Output Clause

Alright have to give credit for this post to Andy because he is the one who pointed out how useful the Output Clause on an insert statement could be. Starting in SQL Server 2005 you could add an output clause to an insert, delete, or update statement
Posted by steve | 0 Comments
Filed under:
Wednesday, December 19, 2007 5:55 AM

The Third Project - Obscure T-SQL commands

Ok so maybe this isn't a project so much as a topic. This will be the first in a series of post dealing with obscure t-sql commands from SQL Server 2000 thru 2008 that I find, that may be useful to other people. Hopefully this will be a weekly series
Posted by steve | 0 Comments
Filed under: