I'm not suggesting...

keil.asta (3/22/2009)

---

I see, I I want the constraint or other method to not allow the user to close the database not at least without warning message. so the message...

Then consider front-end validation. Honestly, that's where the 'you must enter a time' type validation belongs. By the time the data gets to SQL, there's no way to tell if...

Andy Bod (3/21/2009)

---

However my concern is that the database could become very focused on this vehicle table, with most queries accessing this table for their primary information. As such...

keil.asta (3/22/2009)

---

I had thought of doing that, but then it is possible for them just to enter the date part of the field leaving the time part to default to...

The first thing I'll suggest is that you merge the date and time columns. Storing them separately means a lot of extra work to do comparisons or calculations.

So, change...

??????

🙂 I was worried there for a moment

For a 2576 error, the only time the first IAM page...

I've got a small collection of SQL books (10 in total). Disclaimer: Some were given to me by their authors, some are to be given away at usergroup meetings.

These aren't...

😀

Maybe I should have asked how I could tell that from that error, not having your unique advantage. 😉

It's also documented in...

Paul Randal (3/21/2009)

---

Gail - in this case you're wrong.

These errors indicate that the first IAM page for an index does not have an entry in sysindexes. This commonly occurs when...

Or, since this is 2005, sys.db_db_index_physical_stats and ALTER INDEX ... REBUILD/REORGANISE

Both showcontig and...

Also how similar...

These look like homework/interview/exam style questions. Are they?

Then please post the definition of the view, the definitions...