Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Database   (RSS)
Friday, August 01, 2008 1:50 PM

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
Posted by HelloWorld | 3 Comments
Filed under: , , ,
Friday, July 25, 2008 10:22 PM

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
Posted by HelloWorld | 11 Comments
Filed under: , ,
Tuesday, July 22, 2008 8:10 AM

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
Posted by HelloWorld | 0 Comments
Filed under: ,
Tuesday, June 24, 2008 1:17 PM

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,
Posted by HelloWorld | 0 Comments
Filed under: ,
 
Page view tracker