At this point, i am trying to do everything at the database level. There is no application involved, as it is an import (of large amount of data) project. And...

found the error 🙂

The XML files are created with a Python script. In my path, the first &nbsp is recognised, but the second one is actually a \xa0 character(Unicode). I...

Thanks so much for your reply!

It was the encoding part that I had wrong!

Thank you again! 🙂

Thanks for the reply!

I have specified CODEPAGE = 'ACP' and I am trying to import into a varchar column, but I modified it to a nvarchar column also to test...

Given up on it 🙂

It was a small project and we could manually set the background image

Hi, sorry I have no answers to this issue.

We actually exported the Word document and set the background image manually.

Thanks so much for your answers! It worked great!

Thank you so much for your answer!

It actually finished after posting the message 🙂 even though the message for KILL WITH STATUSONLY : Estimated rollback completion: 0%. Estimated time remaining:...

I am sorry, I am not sure I understand the question.

I need for the sum created, to be closest to a given number (10, in the example above), but not...

Thank you very much for all your replies!

You were right about the rule to get the best fit and always fill the batches as full as possible. I am so...

Thank you for your reply!

My situation is that i want to find the perfect balance between performance and data loads and maintenance.

For the query performance issue, i was thinking that...

Again, thank you for your answer and interest ! 🙂

For the article part, i have read it in the past to. I cannot use the DAC connection, but from what...

Thank you for your answer!

Unfortunally i cannot use sys.dm_db_stats_properties, since our server does not have Service Pack 2. It will be installed, but for the moment i cannot use it.

From...

Thank you for your answer!

I already have a query to find modified_count field.

My question is how can i analyse it (modified_count ) to know wich statistics need update?

Yes, I know about that solution and that was my first option, but it seems to not be a good solution for my case. I know what it is required...