I'll have to keep this conference in mind. Even though I spend a lot of time here on SSC, SQL Server is not my primary focus. I'm primarily...

Tim Mitchell (10/28/2010)

---

Good find, thanks for sharing. Have you found the data on this site to be up to date? (That's a question from the baseball fan in...

Seconded about http://www.baseball1.com/ -- I've used this site frequently. In fact, I use the data from this site to practice my own SQL and development skills. So I...

GilaMonster (10/28/2010)

---

Rooms don't have start and end times (unless they only physically exist for certain times and vanish at others)

Schedules have start and end times. Booking slots have start and...

silfolion009 (10/28/2010)

---

i put start time end time and day in rooms and subjects because the system will automatically look for the appropriate rooms in every subjects. w/out time conflicts.. meaning...

I would remove ALL references to dates/times in the room and subject tables, and put them in the schedule table, maybe something like this:

room

r_no

(remove these)

r_starttime

r_endtime

r_day

r_type

(Note: if you're dealing with multiple...

What if it's a rental or a "shared" car arrangement (e.g. Zipcar)?

You're not asleep at the wheel, are you, Dan? 😀

Where did you get these...

First question right off the bat: how much do you know about data normalization? (To anyone else reading this: does anyone have any articles about normalizing data they can...

Bubble Yum

WOTD: Indian Summer (came to work without my jacket for the first time in a couple of weeks)

Okay, this looks good. ...

Hey, if any of you guys know anything about .NET data types, I could use some help with a question over here . . .

Speaking as someone who has collegiate marching band...