I agree. I would be very careful about using (NOLOCK) in production if your data consistency actually matters... According to me people put in (NOLOCK) too often without thinking what...

Bad parallelism seems to me a quite broad term

I have encountered excessive tempdb locking quite some time ago but not because of running...

Maybe you have any job that is scheduled to 'clean' your table?

If it happens on a fixed time/date every month, schedule a trace for that time to see what happens.

And...

Hello,

You have to be a little more specific. What is it really you want to obtain as result? And what is your input? From your example query (that I assume...

Hmm. Okay. But why are you doing this with T-SQL? Is this something you need to regularly do? Where does the string come from? Where do you want to put...

It seems like you are searching for a parser/tokenizer, not a RDBMS solution.

Build/download/buy a parser that puts your data into a DB then do a SELECT with a nice WHERE...

Okay, I have a little much to do right now but if you'd like to change the default Column Max Size for A package:

Open the package in the designer, select...

But if you have DTS packages you can hide them from the user, just remove the permission from the correct system SPs....

I have never heard of this as a problem. SO I do not think this is fixed in a Service Pack.

Maybe it could be called a feature not thought...

Hmm.

Okay, could it be that it is not VARCHAR you are talking about but the type CHAR?

Or could it be that your Field or Row terminator has changed so...

I think he is doing it for BI and performance reason.

What if you only WANT to store a date? For example if you want to store the different holidays... They...

Interesting problem!

DTS can do it, if you set the text delimiters to the character '

But it does not seem to be any native way inside BULK INSERT or BCP to...

Hello.

If your fields are specified as VARCHAR and not CHAR, then you should not run into any error as long as your actual data is LESS then 8060 bytes per...

Yes. You could write a WMI script that checks if the process are running on the remote machine.

I had the same problem. It finally ground down my IO to a halt. Read this KB and see if you have the same problem: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B810885 

My solution was to apply a...