SQL SERVER REBUILD INDEX

Use the script below to rebuild an index on a table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME REBUILD ;
 Check SQL Server...

SSIS Community Tasks and Components

Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free?  Why re-invent...

SSIS ETL Frameworks

In my years as a BI Professional I have seen many ETL Frameworks. They range from homegrown internal solution to...

Dropping a Database

I came across an issue on a server this morning where a drive had run out of free space.  Now given...

Estimated Completion Time for Backups and Restores

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show...

SQL SERVER DISABLE INDEX

Use the script below to disable an index on a SQL Server table
ALTER INDEX MY_INDEX_NAME on MY_TABLE_NAME DISABLE;
 
Executing the...

Start 2012 with Your Best of 2011

The first week following on from the Christmas break is a very hectic one for us Data Professionals.
Your customers are...

Windows OS Information from SQL Server

I ran across a thread recently where someone was asking how to get the Windows start time from within SQL...

How to change the database collation

To change the collation of an database following commands can be used:

ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE  [database name]  COLLATE Newcollation
ALTER DATABASE  [database name]  SET MULTI_USER

For example , suppose if the name...

How to remane a Table in Sql Server

To rename a column in a SQL Table following command can be reused:
SP_RENAME  'old table name', 'New table name'

For example,...