We're just guess here.  Please post the full DDL for the Exampledb.dbo.SourceTable_EF278 table including all constraints and indexes.

It would also be helpful if you if you provided some...

p.s.  If you're "stuck" with an older Standard Edition of SQL Server, the partitioning can still be done using Partitioned Views and, IMHO, would be even more flexible overall than...

I have no experience in storing images in the "File System".

I do, however, have a huge amount of experience in storing "images" (WAV files, in my case)...

I know this post is old enough where the horse has already left the barn but...

The root of this problem isn't what the Developer wants to design.  The...

On a bit of a tangent, I find it ironic that BPE probably works best with SSDs and that SSDs may eliminate the need for BPE.  I know it's a...

Thank you for the feedback and...

Great article and thoughts, Kathi.

One time after making a really big goof, I thought I was going to catch no end of being yelled at.  Still, it was...

Shifting gears a bit but on the same subject, the code at the following link is a prime example of why it takes so long to make changes to database...

This does us no good.  You're showing a table missing something and a query that isn't.  What you need to show us is the actual code that does the table...

When the step fails, you could have it execute a step to send you an email that the job failed.  I typically don't do that, though.

What I end...