Context There was a requirement recently which required changing only the year portion of one of the date fields.The business scenario was to extend validity of insurance details on a table.I’ve also come across similar requests in forums also asking…
T-SQL Tips: Modify All Default Constraints in a Database Based on a Common Value
Context This blog discusses a method that can be applied for doing the modification of default constraints on multiple fields within a database which currently points to one value Scenario Recently in one of my projects there was a need…
IIf function T-SQL vs SSRS Behavioral Difference
This blog explains on the behavioral difference of IIf function between Reporting Services and in Transact SQL.IIf function was a new addition in SQL Server 2012 which provides a simplified way to implement conditionally logic. Though we have a similar…
Know Your DMVs : sys.dm_exec_procedure_stats
Context The impetus behind this post is a technical conversation I had with a fellow team member couple of days back. He was doing the performance analysis of a few procedures in a datawarehouse and was using the DMV sys.dm_exec_procedure_stats…
T-SQL Tips: Multifaceted MERGE Statement
MERGE statement was a very useful addition which was introduced from SQL 2008. It is very useful in lots of day to day scenarios like normal UPSERT (UPDATE + INSERT) operations, slowly changing dimension processing etc. This blog aims at…
T-SQL Tips: Fun with date FORMATing
FORMAT was a new function introduced in SQL 2012 which can be use to format date,numeric values to a variety of different formats and styles.This blog discusses on some of the cool date value formatting tips that can be done…
Troubleshooting SQLServer CDC Service for Oracle Capturing Only Changed Column Values for Updates Issue
Recently for one of my datawarehouse projects we had a scenario which required getting data from a Oracle server. Since this Oracle server was a high end OLTP system with high frequency DML operations happening the impact on the system…
T-SQL Tips: Be Cautious With Your Delete Queries
This blog speaks about some of the critical things you need to be aware of while implementing a delete logic for your project.The impetus for writing the blog is a recent experience we had due to a small oversight in…
SSIS Tips: Extract and Populate Multiple Table Relational Data from Multipart File
I’m back with another scenario regarding text file data transfer.The impetus to writing this blog was recent mail I got from one of my blog followers. He had a scenario which he wanted me to provide him with a solution…
SSIS Tips: Handling Inconsistent Text Qualifiers in Flat File Source
Last week I had blogged about how to handle embedded text qualifiers coming in flat file source data in the below blog.http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.htmlOne of the feedback I got was from a ETL developer who asked whether its possible to handle files…