Amen! I hear that "disk is cheap" all the time from developers. Laziness keeps prevailing where I work, and I'm doing my best to try and make developers aware...

I don't agree with the answer. Multiserver administration is available with sql 2008, unless I'm missing something.

I didn't think you could move the log file with alter... unless you used enterprise or developer version of SQL.

Amy

I just assumed they typed in the syntax incorrectly, so I corrected it for them, and got the answer wrong.

I've seen other times where the syntax was incorrect,...

Can you post your table definition here? What you're describing doesn't make sense. If you add a field to a table, and select * from that table, it...

What's the definition of all the fields in the table you're inserting into? The error message could be related to a different field than the 1 you think.

Amy

I get nothing.

If I hold down the Ctrl key and hover my mouse over the link, then the pointer turns to a hand, and clicking on the link...

I'm using sql 2008, and as others have stated, if I do SET NOCOUNT ON and then run the queries, I get 0,1. Without it, I get 1,1.

Amu

I answered false. I get different results.

I've seen job postings that state "industry experience" required, especially related to financial industry jobs. I agree that data is data, and industry experience shouldn't be required. If...