I was reading that document from microsoft too and I think I interpreted it differently (and incorrectly) than everyone else.  I read it as the order is not guaranteed as...

A different approach would be to tackle this at the application level. The application will grab the entire string from the database and split it in C# (or whichever language...

Something to note - SOMETIMES using a CTE and temp table together will give better performance.  SOMETIMES it is better to look at using JOINs instead of CTEs.  And sometimes...

Admingod - first, do not hijack posts.  Your question is not related to the OP except for the fact that it is about partitioning.

Second, did you read the post I...

Have you looked in BOL - LINK

From a quick google (as we don't use partitioning and it has been ages since I last looked at partitioning), null values are...

I am sure there are multiple ways to solve this problem, but one way (possibly not the most efficient) would be to add 3 more UNIONs, one per possible "blank"...

My solution was a "dirty" one and not one that I'd recommend, but it was required to get the performance back that I needed: modify the hosts file.

Basically, if I...

This looks like a crosspost over to Stack exchange for those curious:

LINK

But I am going to provide an answer as well to the best of my knowledge.  Starting with...

• This reply was modified 5 years, 8 months ago by Mr. Brian Gale. Reason: adding more detail and answering the question

Doing a quick read over the code, it looks like the SQL you commented in should do similar things as the C# is.  The only thing is that if you...

Was just looking at the sample data you have in the attachment and none of those start at 4:00 AM or 4:00 PM.  It looks like they start around 2:01...

You sure you are opening the correct version of configuration manager?  For example, if you install SQL Server 2017 and open SQL Manager 2012, you won't see it in there...

I'm coming in to this debate a bit late, but my preference is to not let users build tables on LIVE systems if I can avoid it.

The developers where I...

Firstly, we have no access to your data, so I doubt you will get a lot of people helping with this.  We cannot see any useful information about your data...

Did a quick google of the error message and found this forum post:

https://social.msdn.microsoft.com/Forums/en-US/531cc114-ffb5-4bad-9ac0-b1d6f0a1d9af/the-current-transaction-cannot-be-committed-and-cannot-support-operations-that-write-to-the-log

Here, the problem was with permissions.

I also found this post:

https://kb.blackbaud.com/articles/Article/53466

which to me sounds like a space issue.  Are...

Heh... I know you meant...