I'd say 319 FK's is a poor design, I've got a pretty big Data Warehouse and the most I have is 20.

funny I'm sitting here looking at the MSDN for 2012 and under exact numerics I see Bit listed there.

I believe in Management Studio 2012 that Ctrl+R doesn't work anymore, unless you customize a shortcut.

Since there was no Use statement, being in the wrong database seem to be the most likey answer to me.

hmm - I'm pretty sure you can mix versions all you want. You are limited to the general functionality and replication functionality of the lowest version. so to...

easy one as long as you as you don't just glance at the answers an then PICK THE WRONG ONE.

How about if you don't have permissions? doesn't that return a NULL?

Can I get 1 point for getting 1 right?

I keeped looking at this one tying to get one of the answers. Got lucky and just picked the closest one.

I also agree with SQLRNNR on this one.

I also went to MSDN and came up with the wrong answer, oh well.

I also think the answers could have been worded different, since it does return a row, but not from the table. Mind reading isn't one of my skills.

MY worst DR story was from 15+ years ago. Had a server failure at about 5 pm at night before the backups occured. All data changes for...

an identity field is not what you want to use. What we have created is the following

columns for the following -

Date YYYYMMDD - type int ...

Why not just use MS SQL Reporting Services or Crystal reports (what ever you reporting tool is) to generate a report, you can have input parameters, the report...