Category: SQL Server 2008

Study resource for SQL Server 2008 R2 Integration services (SSIS)

Study resource for SQL Server 2008 R2 Integration services (SSIS)

  SQL Server 2008 R2 Integration services (SSIS) Creating a simple ETL Package http://msdn.microsoft.com/en-us/library/ms169917.aspx Typical Uses of SSIS Packages http://msdn.microsoft.com/en-us/library/ms137795.aspx Package Protection Level Setting: http://msdn.microsoft.com/en-us/library/ms141747.aspx Running Packages: http://msdn.microsoft.com/en-us/library/ms141708.aspx Logging Package Execution: http://msdn.microsoft.com/en-us/library/ms139845.aspx Architecture of...

describe table tsql

describe table tsql

Currently I was searching describe  like function, which used in Oracle PLSQL to get the detail of table.  I found equvilent function in TSQL “sp_help”. you can used it as sp_help <table_name>   i.e...

Delete with identity reset

Delete with identity reset

I am dropping the rows but insertion start with next to last max identity . Something was missing in my knowledge. To reset Identity i have use one extra statement, other option is use...

How to convert date to interger In TSQL

How to convert date to interger In TSQL

During my assignment I have to generate Integer value from datetime filed for Date Dimension . I found excellent  id this way.     CAST(CONVERT(varchar(8),StartDATE,112) AS int) DateDateKey,   The whole Query is  as follow.  ...

SSIS Community Tasks and Components

SSIS Community Tasks and Components

There are hundreds of free SSIS tools available, which provide additional functionality. Codeplex listed them as http://ssisctc.codeplex.com/. These divided into following sections Tools Connection Managers Log Providers Task (for Control Flow) Foreach Enumerators Script...

BIDS Helper

http://bidshelper.codeplex.com/ There are many advantages in using this tool… 1. The first thing which I use this is for checking the dimension health, this is very helpful especially when you are dealing with the...

AdventureWorks2008R2 download link

AdventureWorks2008R2 download link

Are you searching the download location for sample Databases for Microsoft SQL Server 2008R2 RTM (May 2010) ? You can download it from Click here It contains the complete set of databases: – AdventureWorks...

How to get Tables list in database TSQL

How to get Tables list in database TSQL

  Main object is sys.tables. you can get all information about tables by query on sys.tables.   User databasename Select * from sys.tables;.     SELECT SCHEMA_NAME(schema_id) AS table_schema_name, name AS table_Name FROM  sys.tables;...