Got to go with those yes or no, 50/50 questions every once in a while. Nice, thanks.

I liked this question. It helps add a little perspective when deciding what data type should be used if there is a toss up between float , money or decimal....

I needed this simple question this morning, ignoring the basic issues mention already as can be seen in the answer selection.

I loved this question. I have just spent a few months reviewing this exact thing and how the data space is handled for different data types and nullable/non-nullable columns. As...

Nice question.

As everyone has stated already this should have started by saying in SQL 2008 or higher. In SQL 2005 there is no correct answer.

You got to love those questions that are simplistic enough to make you think twice about the answer. Nice Question.

This question was good.

Follow this path and see if the user that the service is running under is in this group:

-start

-administrative tools

-computer management

-Local Users and Groups

...

I would say if you are worried about something with 2 brands having the same product code then it is a bad design; as you say this is allowable then...

In order for the procedure being executed the caller needs to either have write permissions or a different user with write permissions needs to be used in the 'with execute...

One way would be to have this as a linked server another would be that if it is in storeprocedure and is not an ad-hoc useage for the select you...

Yeah I take this direction and added a db_role called Exec_SP or db_Exec giving the role the securable and just adding users to the role. To me it seems more...

Granted there is a margin of error for rebuilding indexes but that can be taken into account when the process runs with different types of maintenance windows (i.e. audits are...

I am not extremely versitile with bcp for the in direction, you can try these options instead -c -t, -T as the -c is normally expecting tab delimated the -t,...