Nice question about new functionality...

Agreed

Felix Pamittan (5/5/2016)

---

Correct answer:

Yes, you can run this code, This returns 97

Explanation:

You can run this code. The CHAR variable is converted to NCHAR and the first character's value...

Interesting question, thanks Steve

Haven't used log shipping in years (well, since 2012, in any event), rather use AlwaysOn Availability Groups....

I run sp_help_log_shipping_monitor_primary and get information back. Two questions: from...

Good question, Uwe, thanks.

enjoyed puzzling it out.

good explanation, too

but the answer appears to be a contradiction of terms:

The statistics for the non unique index will be updated because it is...

Nice, simple question, thanks Steve

Nice, easy one to end the week on, thanks, Steve

According to books online, last_access_time is a not null field, with a default of Current time

Never thought of using FQDN myself, so I learned something new from this discussion.

SQLRNNR (11/12/2013)

---

Though i understood what the OP was trying to achieve I don't like this particular question and I don't like the supporting documentation.

Vardecimal existed only in SQL 2005. ...

Agree with Paul

without table definitions, it was difficult to make an informed decision.

This dudes socks must have some potent stuff in them, if smoking them gets to the answers provided. :ermm::-P