Shot in the dark... have you tried doing a manual CHECKPOINT in the database?

I found the problem when data was extracted it was a point in time, and on one of the files the last record was partial written.

Is there any any...

Having a weird case today (still under investigation). Parallel clustered index scan slower dan serial index scan (forced by MAXDOP 1)

*edit* repartition streams spilled to tempdb 🙁 Repartition stream...

Thanks for the information.  If you're happy with...

Heh... I hope whoever does the picking has a good sense of humor.  I had some serious fun with pronouns and disabilities when I submitted last night.  The abstract is...

I have a folder with csv files that has 2 columns a datetime, and a integer value. I want to load them all to a SQL table, but I...

As a bit of a side bar, there's little chance that I'd leave such a delimited column in one piece.  I'd have split it into separate attribute columns on the...

Never mind.  I'll just assume that ties for first need  to be displayed.

    WITH cteCount AS
(--==== Do the math, which seriously reduces the rowcount...

Hi ! i got a task where i am to post only the Reshnum of the Department with the highest count of admissions. there are two tables relevant to...

You have been working with SQL Server for at least 12 years and 8 months according to your profile.  With that, you should know what I'm going to say... it's...

I like the Dog Mode having a big sign on the display and the temp setting. We'd certainly use that with our pups.

I'm torn with a lot of the...

That "dog mode" feature is interesting, but even then I don't think it will necessarily prevent your vehicle from attracting unnecessary attention. I have tethered my dog to a...

I just don't know enough about the data nor what the rules being following for which prices to use are.  I also suggested that you'll need to add the extra...

My question is ... is that the only error that...

Lordy... not another one... 🙁  Jumping straight to the final two questions in the "experienced" section...

Without loading it into...