What would the correct syntax be, to generate a table of numbers 1 to 10?

Never used this, but doesn't the result depend on MonthDayPattern (i.e. it will come out differently for different cultures)?

Plus you will end up with ambiguous results like 'October...

OK, I am even thicker (US dumber) than I thought! I didn't look at the question properly, worked out the difference between the dates as if they were American format...

American dates are weird.

Just to be pedantic, the thread doesn't randomly pick a CPU, the operating system moves the threads based on workload - but hey, I knew what you...

Should be @read_only rather than @readonly, but doesn't affect the correct answer - nice question.

Luis Cazares (12/8/2016)

---

I don't find the confusing part. Or maybe I just noticed the 3 hints to the correct answer.

I need to ensure the databases are backed up while minimzing...

Thanks for the question - a nice one for Zombies. 🙂

"Number 4 works for this year only."

Actually it doesn't even work for this year.

SELECT DATEPART(DAYOFYEAR, SYSDATETIME()); gives 329

SELECT DATEDIFF( DAY, '20160101', SYSDATETIME()); gives 328

Happy Thanksgiving to all in the USA.

I'm confused.

The correct answer is given as:

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

The explanation is:

Of these, the this item is invalid.

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

SQL Server...

I disagree with the answer - the question says "I find that the audit is no longer needed...", not that the audit specification is no longer needed - it could...

BWFC (9/2/2016)

---

+1

There's nothing in the question that suggests that there are SPARSE columns. It's not something that would jump...