Steve,

Thanks for the question and the great site.

We're not on 2016 yet but it was/is exciting when they announced these features being added to Standard Edition.

As for the...

J DBA (11/2/2016)

---

Iwas Bornready (11/2/2016)

---

DamianC (11/2/2016)

---

Expected 1 and 2 ; went for 2 so guessed wrong

Now run this through, as with others, both 1 and 2 fail

Can't see this been...

Iwas Bornready (11/2/2016)

---

DamianC (11/2/2016)

---

Expected 1 and 2 ; went for 2 so guessed wrong

Now run this through, as with others, both 1 and 2 fail

Can't see this been SQL version...

Igor Micev (11/2/2016)

---

Henrico Bekker (11/2/2016)

---

Nice question, technically both:

1. INSERT dbo.TimeZoneOffsetTest (mytime) CAST(SELECT '20161015 08:15 -4:25' as DATETIMEOFFSET)

and

2. INSERT dbo.TimeZoneOffsetTest (mytime) SELECT '20161015 08:15 2:00'

are invalid, option 1 contains an...

Thanks for the question Steve.

It's nice that at least in install it is forcing strong passwords. I've worked many a place where the sa password was an easily guessed...

Obviously a case of the hierarchyid option not being checked in the official answers. :Whistling:

Thanks Steve for the question about a new feature.

JDBA

tindog (6/1/2016)

---

cad.delworth (6/1/2016)

---

Just the smell of coffee makes me want to vomit (literally).

Any workplace that has a coffee machine dominating it, is somewhere I will definitely NEVER take up a...

13.0.1500.24

TMiller 21949 (4/7/2016)

Not just Colorado.... Cape Coral, FL... although there are exceptions, streets that can get you from Point-A to Point-B (lots of streets cannot do that - the place...

I agree the question as written has had no correct answers.

I approached this like I do issues in my systems where sometimes you don't have all the information as to...

Sounds like those of us here on SQL Server Central are doing...

I almost picked 7, but then figured that would be too easy. Then I found the video on your blog and tried counting them. I wasn't quite sure...

sestell1 (3/26/2014)

---

Toreador (3/26/2014)

---

Nope, based on the preamble

first...

It was the DST change that got me. I was so tired that the double negatives confused me and I answered in the double negative and selected all the...

h.tobisch (3/10/2014)

---

Sorry, you are wrong.

As Memory Optimized Tables are memory resident, the data is Not-Durable upon System Restart/Crash --> this means from A you can deduce B.

As this cannot be...