I agree with irgp, it makes no sense to use UNION here. At least not with the information you have shared so far.

Yes, it is possible. There are three different ways to go:

1. Enable cross-database ownership chaining.
2. Certificate signing.
3. EXECUTE AS.

While the first is the simplest, it also opens for a security...

Your question is not very clear. You talk about 3rd index, but in your example you only have [1]. And (/Catalog/book/title)[3] does not make much sense, since there is only...

OK. By default you'll always read the last committed value, using standard READ COMMITTED (hence the name, I guess :-)).

...or you will be blocked if RCSI is not enabled.

Your point...

Yes, if userB uses WITH (NOLOCK) on the table(s), or READ UNCOMMITTED isolation level

But Scott, "IT Researcher" asked "is it possible for userB to read last committed values" and the...

When you use SNAPSHOT isolation, you are completely blind for changes that occurs in the database after the transaction started.  Thus, userB does not see the changes from userA.

Yes, if any form of snapshot has been enabled for the database.

ALTER DATABASE db SET ALLOW_SNAPSHOT_ISOLATION ON

UserB can now read the the most recently committed database, if the user first...

Since you are moving to SQL 2017 Standard, why not copy a backup and restore on SQL 2017 to run DBCC CHECKDB on this machine.

As I said before, I suspect...

You would only considering putting the ndf files on different drives, if you have an enormous loads on tempdb. And it would only be meaningful if you have a super-duper...

If I am to make a guess. the Postgres optimizer has a rule, so that it can deal with the condition

((((CONCAT(t1.BRANCH_CD, t1.PRODUCER_CD) IN
('80213','91143','90212','902112','922'))

whereas Oracle 10G has not....

So how big is tempdb? What autogrowth settings does it have? How much free space is there on disk where tempdb is located?

Is this Express Edition or not?

I seem to recall that IT Researches uses SQL 2008 R2 Express. The space needed for tempdb is 20 GB which is above the database limit for Express. I am...

What sort of foreign key do you have in mind? The XML column itself cannot be a foreign key, since you cannot have an index, and thus not a primary...

What is really optimistic is that you expect that someone without knowledge about your system would know where these files are located on this machine. If someone told you that...

I might have missed something, but I have never heard that Linux comes with a database. Maybe you could clarify?

Or do you mean an SQL Server database running on Linux?...