Getanothername, wouldn't you expect error checking to be handled by constraints rather than the query to select the data?

What should the output look like if the last frame bowled was a strike and it wasn't the 10th frame? A NULL, maybe?

Frame 5 ...

Number one reason not to use the debugger is that, simply put, it sucks!

A) You have to type in all of the parameters.  This can be extremely time-consuming if you...

Linda,

You can try sp_attach_single_file_db, which once again MIGHT work, IF conditions were correct at shutdown...  But the only way to guarantee that attach will work is to detach the database...

The "correct" answer to this is a *BIG* maybe.  IF the transactional state of the database happened to be clean when it went down, then this might work; otherwise, you...

I think DanaH1976 had the right idea; assuming your company's structures stay static and they don't re-shuffle management/groups on a very regular basis, that solution will provide you with the...

Best question in days (or perhaps weeks).  Even if the answer was slightly wrong

There's nothing inherently wrong with using surrogate keys.  Even most so-called "purists" have no problem with it as long as uniqueness and integrity is enforced using constraints and the surrogate...

Nothing wrong with using EM for backup/restore!  It's a lot quicker, unless you've done the work up front of creating QA templates for all of the common manual backup/restore operations (which,...

Very badly worded question ... "making sure you use ..."  What does that mean?  Use for what?  How about "making sure you DON'T use (the same filename)"?

Thor:

DataDynamics ActiveReports can.  I've used it quite extensively and IMO it's a pretty solid product.  Better automation capabilities than CR and very cheap too.  I haven't tried MS Reporting Services yet though,...

Serialization, IMO, defeats the purpose of having a DBMS and brings us back to flat-file land.  Part of the definition of a DBMS is that it's shared - many processes can...

Tatsu:

Are you talking about using a queing system to serialize database access?

Thor:

There is a fine line between "business rules" (e.g. constraints) and "business logic" (e.g. if user enters something in this field, pop up this message)... It really needs to be...

An article by C.J. Date on data models, what is a data model, and (more importantly?) what's not:

http://www.dbdebunk.com/page/page/622923.htm