Arrgghhh, I officially hate this question.

I must have forgotten to hit save.

Question:

I have a simple table:

CREATE TABLE TimeZoneOffsetTest

( mytime DATETIMEOFFSET)

GO

Which of these is invalid for inserting a row?

Answers:

a)...

Corrected now. checked the wrong box.

Perhaps one way to make restores easier is to generate the restore script at backup time for any particular full backup.

That could be a great way to improve the restore...

djackson 22568 (11/10/2016)

---

Let's face it, there are people who are extremely intelligent, all the way through dumb as a rock. IQ tests are built to measure this very concept....

mjh 45389 (11/10/2016)

---

I can only see it being of use if it is done well. Over the last thirty years the bane of my life has been people who have...

skeleton567 (11/10/2016)

---

Sure, and more people should drive 18-wheelers on the interstates. I think I'll go over the airport and volunteer to fly a load of folks to Chicago today,...

roger.plowman (11/10/2016)

---

Having been a developer for 30 years now I hate to rain of Steve's parade, but perhaps I have a different view of what he means by coding than...

I would tend to use Gail's advice. However, if index rebuilds are your largest operation, and you can size the log for that, then it's not a bad way to...

A partitioned table actually is a split of a table into sections. Right now, your tables are really set as pages, and you treat the table as one object. You...

Usually you need a system level account. Can you post the OS error and service account permissions?

Doctor Who 2 (11/5/2016)

---

This article has me wondering about my own account. I have an account with Wells Fargo. Naturally they've been sending out emails saying things like they're sorry,...

ZZartin (11/4/2016)

---

Steve Jones - SSC Editor (11/3/2016)

---

ZZartin (11/2/2016)

---

I don't feel it's the job of IT to play vigilante and hunt down people potentially abusing the system, unless you work in...

Rod at work (11/4/2016)

---

Steve Jones - SSC Editor (11/3/2016)

---

Ralph Hightower (11/2/2016)

---

I don't think that a computer system could have detected the fraudulent activity at Wells Fargo. This was a systemic...

It's part of the forum software. I assume we could put something in there, or you could add certain events. I'd like it removed because we haven't ever really used...

I tried this morning and it seemed to work for me. Did you specify AdventureWorks2012 as the datbase? Don't leave it as default.