I'm not usually one to start an argument, but I have to say questions proving to have wrong or ambiguous answers to questions aren't the only trends i'm noticing at...

That doesn't help you when you have 3 options in front of you that don't make any sense, you're not easily able to read the thread until after answering. I...

Yeah it was perfectly easy to understand. Plus it would be a radio-button answer if it could only be one of them, multiple choice implies multiple results

I'm glad you've found this conversation interesting; I have too 🙂 I tend to think these questions are like ones you get when you go for an interview for a...

Robert,

With regard to your first point, the question says

all English letters, both upper and lower case mixed with numeric digits

These are all a part of the standard ASCII character...

I'm with Rob, I got this one right (for once!) but often it's these little details that let me down in these questions. Different data type can completely change...

I thought he was pretty clear on the details. There was a similar question a few months ago that simply asked which was more efficient? Char, varchar, nchar or...

Sorry for taking so long to come back to this. I have been so swamped with other work I haven't had a chance to revisit this.

Andy - I have...

I'm not trying to be difficult here but I have to disagree with you bitbucket.

If I write an update statement i get a response along the lines of

23 row(s)...

And I was the unlucky one who guessed the other way and got it wrong. Answers 1 and 2 are the same, but imo answer 1 is more correct, since...

Hi Rothj,

The database is stored in the same location as the old one, they both exist in the same instance, just with different collations. I think on that basis the...

Sorry to bump this up but does no one else have any ideas with regard to this?

I have tried going step by step through the database creation process, recording the number of extends used at each step. Everything seemed ok until i got to some...

Jeffrey,

I did as you suggested where tables had any contents and it made no difference. I'm going to try copying again from the second DB and check the space taken...

Michael,

Thanks for your reply. I had already seen your code though I hadn't run it until now. Here are the results. I won't post my entire table listing but...