Posts

Some Shortcuts in SSMS Query Editor

6 comments

Few SSRS Issues and Workarounds I encountered

Post a Comment

Converting non-ansi *= or =* to SQL 92 type / ansi joins

6 comments

Did you know that ISNULL function can take Query as a parameter ?

2 comments

System Table Queries (2000)

1 comment

Passing DataTable into a StoredProcedure

Post a Comment

List of all Procedures and dependant Tables that are updated using linked server

2 comments

Query to get a list of foreign key constraints for a table

Post a Comment

Keep a check on your IDENTITY columns in SQL Server

Post a Comment

About Data Profiling Task in SSIS 2008

1 comment

My feedback for SQL Server 2008 February CTP-6.

12 comments
Image

An approach to Load fact and Dimension tables

8 comments

Useful Oracle SQL PL/SQL Code Snippets for my Reference

7 comments

Useful T-Sql Snippets for my Reference

Post a Comment
Image

Conversion of BRIO to SSIS Made Easy

5 comments

Get the Row Counts for all tables in Database in Sql Server 2005

1 comment

Solutions to space and performance related issues associated with tempdb in Sql Server 2005

4 comments

One of the best approach to load data into Oracle data mart using SSIS

2 comments

Extract Last 12 months data if you have a Month_Code Column of the format 'YYYYMM'

1 comment

Synchronizing all Instances for NLB using ascmd Script

Post a Comment