I agree. Qods have become so careless and subjective as to be worthless.

As everyone else has noted, wth does "dob" have to do with "join" date?

Because then the exact same check that works...

Wouldn't L.A. fall under CA law?

Where...

But even your own "timeanddate.com" link makes it clear that the official birthdate is Mar 1 in non-leap years:

while others celebrate their birthday on March 1 because they do...

So when someone asks you how old you are, you count days before you answer? Nonsense.

The best...

Well, I guess it's nice to see that there are still places where low standards prevail and former govt employees can find actual work.

I admit I don't care for all the "uber-geeky" solutions; it's just too hard later for s/o later to verify that the code produces a correct result.

But leap year birthdays...

That's for sure. I love "experts" who don't know how to tell what the current SQL activity on the box is.

Interesting. I guess my concern is that if a (very) large table(s) need updated, you could see a significant hit to your performance from autoupdate of stats. Also,...

First, 100% on the honesty thing. I would detect you and not hire you. Moreover, I would add you to my personal file of "never hires". Just...

Hmm, but happens if/when your requirements change and a table that was a "prime" table becomes an intersection table, or vice versa? Do you go back thru and rename...

Regarding table names, I now prefer singular but can live with plurals ... the main thing is consistency. Whichever you choose, use it thru-out, without regard to whether it's...

I've read everything: interesting article and comments!

FWIW, here's my take on a first-cut design *for just books* [personally I would adjust it to allow reviews on other objects -- such...

I need to find the record in the DB that has a start time >= the time of my call and on or after the day of the week...

I think you need to check the current date instead of automatically using s.enddate in the calcs. For example:

DATEDIFF(DAY, s.startdate, CASE WHEN GETDATE() < s.enddate THEN GETDATE() ELSE s.enddate...