Thank you for the thoughtful reply.  Indexes can be a load of "fun", especially when they belong to 3rd parties that have such things a VARCHAR(1) and other datatype attrocities.

You...

@JeffModen,

Okay, I know it took longer than expected, but I finally got my hands on the code that updates that table.  Here's the process.  Once a record has been...

To help resolve this problem across the board, for all your queries, you really need to re-cluster the CommoditySupplier table.  This is a classic case of the "default clustering...

I have to disagree a bit here.  Changing from 55% memory utilization to 70% is almost a 30% increase in required memory.

I'd do a search for one of the many...

The see...

Prior to doing a fail over, see if there are any Killed/Rolled Rollbacks.

If there are, I'd say there's a 99.5 % chance that you've been bitten by a problem with...

Yes, you can do it using something like VirtualBox on your PC - but you'll need to have plenty of RAM and spare disk space.  There are various...

The see the...

Hi Guys ,

I have column with Values like 1111\123132\34342323\1212. I used the above code to split it . But this doesn't work. The code returns blank. Can you please...

I don't know much about SSIS but, if I had to guess, I'd say that the 1900 date has absolutely nothing to do with file names.  I'd say that SSIS...

p.s.  You might want to post the stored procedure and the contents (or a least a sample of) the control table.  See the first link in my signature line below...

Probably...

Hi Jeff

Yes the datatype is represented that way within the DB.

I'm also worried about Policy and BatchMonth. I will talk to the Database Administrator as Policy should be Char while...

Short, sweet, and very much to the point.  Nice job, Mike.

Like Brent Ozar, I'm really excited about a lot of things coming out in 2019 but, once again, MS has produced a poop sandwich and, everyday,  you must take a...