Sorry Kelvin, but there is clearly a difference between a "maximum limit" and a "limit". The default limit is 64K and the default maximum limit is 2GB.

Maximum value...

There seem to be well known problems with job history and summary information being wrong. A thorough search (google, here, etc.) shows that others have reported the same problem...

I would suggest that the question be stated as:

What is the default size limit for text replication?

That does not imply that it is the "maximum limit" rather the actual operational...

The question does not specify whether or not a WITH VALUES clause is used.

In the absence of that clause the values are not applied to existing rows and they will...

Editors are asleep at the wheel or needed some extra page views on the forums to drive up ad revenue.

Points please.

If the columns in the select-clause only come from the address table, then I think you can drop the "join names n on ..." clause because no columns are selected...

The joins without columns in the select can be used to filter data as if there was an EXISTS or IN clause. These are not outer joins so they...

I would suggest that instead of YES/NO questions, that these sorts of questions should be HOW.

The answer to this question was clearly yes, because one could set up...

In the case of data warehousing, I agree.  Each dimension should have its own table for performance and maintenance reasons.  More importantly, dimensions are often more than just code lookups and...

Also, I wasn't sure if there was any significance to the placement of the answer "They all support the same...".  It was in the middle so maybe it just...

Did you actually check execution plans for each method? 

I'm just curious.  I would bet that the OR gives better performance, but it depends on the data itself and indexing.

Maybe I'm just a stickler for correctness, but the question should read:

Of the following, which edition of Microsoft SQL Server supports the largest database?

The ISNULL solution is not bad, but, as the author indicated,  it can result in full table scans.  You can probably avoid that by using an OR clause that will short circuit...

We've run into this on a server here.  It seems to have fixed itself once we created and ran a One-Time schedule for a job whose schedule is usually every two-weeks. ...

What does Explain Plan Show Execution Plan show? 

Sorry, Explain Plan is a common term and I've heard it used with SQL Server too, but mostly by ex-Oracle DBAs.