Dan Guzman - Not the MVP (12/19/2014)

---

Gaps I don't mind, but really 1000 or 10,000 at a time? It's too much. I guess if you only reboot once...

Also note that with Replicated Tables you can/will also have gaps, as each subscriber of the published Table is pre-allocated a range of IDs it can use.

Each month has field which states how many weeks it has, this year and last (4...

ian.fickling (9/6/2010)

---

...

As Cliff Corder mentioned earlier the diggest difficulty with 445/444 is that you end up with 364 days a year. Each year your calendar drifts a day eventually after...

Not SQL-related, but in Excel I created a staff incentive scheme for a company using 4-4-5 ,and then had to 'adjust' every 3 or 4 years to bring the weeks...

I'm surprised that this is treated as a T-SQL issue rather than Administration, as I regard database space creation as Admin.

To me, T-SQL stands for 'Transaction(al) SQL', and I...

Ah! I see ... Like those psychological tests where what they're testing is not what they tell you they're testing, because if you knew what they were *really* testing then...

Hasn't anybody noticed that the *none* of the 'weird datetime conversions' answer options actually gave the answer (1899-12-31 00:00:00.000) ??

I expected that I'd get the 0 result, but wasn't sure about the message. Anyway, I got

"

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

Warning: Null value is eliminated by an...

I got it right (guessed that it would sort alphabetically to remove duplicates, but that's not guaranteed, as mentioned)

However, I reckon that *none* of the answers are (or should that...

IANAL = I Am Not A Lawyer

^H = control-H = backspace 1 char (old Teletype/CPM/MS-DOS control sequence), gives IANA = I Am Not A

DBA = .. this is left as...

I got it wrong, but nothing to do with the use of the word 'GO'.

As I calculated in my head what would happen, I had to make a guess as...

SQL Server should act like a Finite State Machine, to be able to predict its behaviour...

Please explain how you got 2009-01-31 12:59:59.128 (as in, ending with...

Hugo Kornelis (2/17/2009)

---

Finally, the datetime datatype is not inexact. It is basically a counter of the number of 1/300 second intervals since a fixed starting point (midnight of Jan 1st,...