Performance Issue in Slowly changing dimensions of SSIS

We had 200's of packages in our project and I came across a package which was taking enormously long time. I debugged the package checked the log. My doubt was that it was indexes due to which the package is running very slow and was taking around 2-3 hours usually.

To know about indexes kindly read my article:

http://rajjawahar.blogspot.com/2016/09/indexing-in-sql-server.html

I tried everything.  Removed indexes, kept indexes added NOLOCK but still it was taking the same or sometimes more time than that. From the log it was very much clear that the culprit is SCD.

I found one thing in the SCD and experimented with it and luckily the performance was increased and to what extent. It was now able to complete in 1 minute, I was amazed and my lead was very happy with my findings.

The root cause of the slowness was because of Business key which was not contained in any of the indexes and due to which when the Updates Output component was called it was taking huge time to locate the row from the table.

Now once I added the Non Clustered Index on this Business Key field it was running very efficiently. It was now 120 time faster.

doing investing with intelligent approach

Hi all, I hope you had liked my previous blog about discussing stock market investment with father:

http://rajjawahar.blogspot.in/2016/08/stock-market-investing-discussions-with.html 

So let us move further in the world of investing, so once you start investing we thinks very positively that the stocks that we have chosen will give us very great returns. Also to find good stocks we do lot of research and our most of the time goes into this. It takes a lot of time due to which many people not able to concentrate on their jobs as well.

If you have a portfolio and keep a track of stocks you will find that out of 10 stocks you are able to generate 30-50 % returns from 2 or 3 stocks but other 7 are either generating negative returns or an average returns.

So out of lots of discussions with my friends I found a way through which we can invest for long term and gets a good return:

1. In the stock market only bet on the Large Cap stocks which you know and only when they are near their 52wk low

2. Invest in small cap/mid cap stocks through 5 star mutual funds with SIP option. Also invest in lump sum when the market is very much down.

Indexing in SQL Server

Hi all today we are going to discuss about Indexing.

What is indexing? Have you thought what would happen if it was not there?

Basically indexing is a SQL concept that is used to retrieve the data from the database in fast and efficient way. If it was not existed then fetching data from Databases would have taken hours/days/Months and we would be standing hungry in queues of the food chains of McDonald'/KFC for long hours.

Let's see how it works:

Have you imagined how you can search chapters if you don't have the index in your book?

Book is the perfect example of indexes, suppose if any of your teacher asked you to show any random chapter content. How will you show her/him?

You will navigate to index page of your book and will find out the page number. In this way you would be able to track the chapter in a quickest way. On the other side if you were not having the index page in your book, you will have to jump from one page to another till you would have found it.

As you can see indexes in the book helped us reduce the time significantly, in the similar fashion indexes helps tables/views to find the data quickly.

Stock Market Investing discussions with Fathers

                                                   Stock Market Investing discussions with Fathers


In the most of the families, when the child starts earning. He starts feeling very good when the first salary gets credited into the bank account.

Slowly he gets used to the salary and then after some months this salary looks little tiny. Then from somewhere he comes to know about Share Market. He then search about this and find many peoples who are earning a lot by doing investing/trading.

But when he chat about the same with his father then he receives one guidance never play with Stock market(paise doob jayenge). He will remind you about gupta/trivedi uncle who had lost a lot money in the Stock market. He will not listen to you in-respect to Stock Market.

Here is the time most of the people lost the interest about stock market and then never comes into investing. But if you come back into investing there you understand the power of investing. The people with whom you will hangout/live your thinking would be the average of those peoples so start exploring the different ideas.