I'm not sure why Jeff keeps talking about the version of SQL Server. We are not talking about BULK INSERT here.

As I understood the original post, VSCurtis right-clicked the database...

To beat this dead horse a little more: CSV may be an industrial standarad - and I think everyone here knows that. But while the CSV format may include column...

To Repeat.... CSV files are industry standard files. There are NO default values for field size.

But in SQL Server all columns must have a size. No matter if CSV files...

Maybe it was a trick question where the expected answer was "you can't do that" or "that's a completely meaningless thing to do". Remember, the purpose of interview questions are...

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?