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, 11 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...

I think it may depend on the purpose.  If the table is going to be used to store vehicle information to be used by an external system, then Joe's method...

Not meaning to hijack the thread from Phil, but the error is clearly stated in the last bit of errors you posted:

Description: "The Microsoft Jet database engine cannot open the...

I would not recommend using VSS for a backup strategy personally.  SQL has a built in backup tool; I would use that.

As for the legality of using the tool that...

I am pretty sure that that would violate the license terms for any tool that is out there.

I highly doubt you will find anyone willing to do this for you...