You say you want it to be displayed "just like the calendar entries are shown on a regular calendar".  If you have 500 to 1000 jobs on a server lie...

First round of testing to 1, 2, 4, and 8 files on a single SSD drive of a minimally logged, single connection insert of 10,000,000 rows @89GB of a table...

Heh... an early look scared-up the ol' "not unless they're on different physical spindles" adage.  While I logically agree with that, I've never actually tried it and so I don't...

Getting back to the original question, we're just guessing based on related information supposed "Best Practice" information and, by now, I'm sure everyone knows how I feel about "Best Practice"...

Just like index maintenance and a couple of other things, it's better to NOT do something than it is to do it wrong and, thanks to the poor examples in...

It's late, so I might be missing something here.  Are you saying that...

Ok.  First, I cleaned up the code that provides the test table and data generation so it's easier to read/verify.  I also changed it from a table variable to a...

Missed David's post, which he posted while I was still writing.

If you've not solved this yet, especially with the special condition for things like "30_000" where the underscore is actually a space, and no one...

They are still image and text data types (legacy industrial tech "we will not change it for you" salesperson ). Out of row by default if I'm correct., but...

As a bit of a sidebar, if you're going to store LOBs in the database, do yourself a favor... force them to behave as they did with the old style...

In which dialect of SQL?  That will not work in T-SQL (SQL Server).

Apologies in advance for the rant but I'm fed up with developers who go to great lengths to re-invent the wheel simply because they don't know how to do...

So, you're happy with the answers you got on this thread?

As for T-SQL job step vs. running the .Bat file, that discussion is a little more complex. It could be that NorthernSky needs to run the same set of...