Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?

I made the same mistake as the question setter, hence got it right! 😀

I looked at the first option and was disappointed that the second one wasn't

Eugene Elutin (9/6/2012)

That was just an example. In production you would do:

1. SELECT DISTINCT * FROM MyTable INTO staging.tmpMyTable

2. TRUNCATE TABLE MyTable

3. (Power outage)

4. Er.....

5. Server Restart

6. INSERT...

Approach can also depend on whether this is a one-off repair or something that needs to happen on a regular basis. It's also wise to avoid the following scenario:

1. SELECT...

Not something I'd know instinctively but was easy to look up. Had to read the options carefully too!

Nice to have an easy one after yesterday!

By not choosing the option which said

I earned points quickly and easily and...

...or INFORMATION_SCHEMA.COLUMNS

I'd also recommend installing SQL Search which is a free tool from Redgate. That will find things quickly, even if you don't know exactly what type of object they...

I'd be tempted to have a celebratory "moment" if I managed to interface a Mac to anything. 😛

Well, I'm British and I don't know anybody who has ever used YDM format. We go for DMY or YMD.

All looked good to me - thanks for the question!

Any ideas on the performance differences between the INTERSECT and INNER JOIN methods?

Remember that a lot of us aren't administrators but developers. We have other people to sort out that sort of thing for us 🙂

Nice "real world" question today. Thanks.

A decent notebook and a Parker Flighter 45 (fountain pen) have served me well for many years 🙂