SQL DB Pros

Tag: SQL Server 2005

  • SSIS Compare Variables And Change One With A Script Task

    This article falls into the half baked posts category.  Once I figured out how to compare two variables and then overwrite one with a script task in SQL Server Integration Services, I also realized I did not in fact need to perform the task.  Doh!  Still a useful bit of code though so I’m posting […]

  • SSIS: No column information was returned by the SQL command

    Are you trying to use a stored procedure as the source of a SQL Server Integration Services (SSIS) data flow task?  If your stored procedure contains a temp table you may run into the message “No column information was returned by the SQL command” (complete error message below).  Although there are a number of solutions […]

  • Find User’s Default Schema

    Need to find the default schema for a user in MS SQL?  Need to confirm all your SQL Server users default schema’s are set correctly?  Easy peasey.  Run the following query and enjoy.

  • Find Tables Without Clustered Indexes

    Need a way to find all tables without a clustered index in SQL Server? Running this script every once in awhile will help ensure best practices are being followed and every table has a clustered index. This script is compatible with SQL Server 2005 and SQL Server 2008.

  • SQL Server Combine MDF Files – The Easy Way

    Do you need to combine or merge two data files (MDF or NDF)?  There are a number of complicated options available or you can use the two lines of code below to do the trick… It’s up to you.  This method works with both SQL Server 2005 and SQL Server 2008.

  • SQL Server Rebuild Indexes – The Fastest Way

    Want to rebuild all the indexes in your MS SQL database?  The script below will rebuild all the indexes in your SQL Server 2008 or SQL Server 2005 (SP2) database and offers a number of enhancements that make this the best SQL Server index rebuild script in all the land and the first choice of […]