Hi Ravi,

I am also facing the same problem... If you have found solution, can you please post it so that every one will be aware of.

Thanks

Hi sharda,

This seems to be problem in your application, I suggest dont use the free memory cache function again and again in sql server or dont create any service to...

if you are getting 503 server unavailable ... its not DB issue. Actually it is be throwing from web server. We need to check the web server log or debug...

Hi Gail,

Thanks for your comments.

What is the difference between minimally logged and fully logged. As per my knowledge, only the difference is, in minimally logged the the...

Yes. My assumption was correct.

There is nothing which cant be logged. But most of the people will think bcp will not be logged where as a simple insert command...

I agree doing this in a loop or in chunks will give complete control. I too have experienced same problem.

I have a question here : bcp will log or...

Yes, it is helpful if you can provide us sample data.

@Sushant... i assume you are night shift 🙂 ?

That is just to make sure the db is in good state before you run rebuild. Its required.. just to check..

If...

Thanks Gail... giving correct information.

Yes update statistics will update stastics of columns.

But its good to update statistics frequently on heavily running transaction database.

As you may be planning for...

Yes db shrinking obviously affects performance. If you dont have space .. forced to do that.. you do.

Normally its not a good practice to shrink the db frequently.

The order may.....

1. Have you tested db mail creating profile and account?

2. If Yes still u r not getting the mail.

3. Check whether the you have the account mapped to the default...

Hi andy,

Is your problem solved. I am also having similar issue.. where website is showing 503 service unavailable error .. for which we are doubting its of because DB.

Hi Vena

Please check this link

http://munishbansal.wordpress.com/2009/06/09/dynamic-columns-mapping-%E2%80%93-script-component-as-destination-ssis/

you will get lot information on dynamic mapping of columns.

I hope this will help.

on same lines can you tell me which operating system we can use...?

Thanks jeff..

I will consider your suggestions.. I will try that. I am also thinking on setting fill factor.. as I am updating table several times which leads to page...