How to Find Out Which Column Caused SSIS to Fail?

In my previous post, I explained how you can find out the error description for the error id that is returned by SSIS. Of course, that information is only half helpful, debugging the issue also involve knowing which column caused that error. The Error Column returns an integer value which is also a little bit…

7

How to Decipher/Understand SSIS Error Code?

If you have worked with SSIS, you may have been doing something like this, in case of errors, you saved the error code and the error column to a text file or some other media. If you get the error within the IDE, that is cool, as you can get more readable information, but if…

13

Boosting Performance with READ_COMMITTED_SNAPSHOT

I had a problem with one of our database in our testing environment, it performs OK, but we know it can be faster. There are millions of data in that database. Everything are properly indexed and the stored procedure plan is optimum. I was not aware about read committed snapshot option when the dba suggested…


Database Design – Designing Primary Key

One of the key of designing a database is picking the right primary key. I keep in mind several things when I design a database: If possible, primary key should not have a business meaning. Business meaning changes, some attribute that is unique now, may not be unique in the future. Related to that point…