Great question! Thanks!!

bkmsmith (5/1/2014)

---

gbritton1 (5/1/2014)

---

Before I answered this question, I read

It reads, in part:

The hash join has two inputs: the build input and probe input. The query optimizer assigns these roles so...

Great question, very interesting!

I wouldn't have guessed that.

Interesting, I didn't know a key could support decryption via two different certificates at once. All the examples I've seen add a second and then immediately drop the first.

mickyT (4/13/2014)

---

The concept of putting the foreign key on databases didn't make sense to me.

Wouldn't it be make more sense to put the foreign key on the backuplist...

Nice question, thanks! Definitely something I'll be doing some more reading on.

timwell (4/9/2014)

---

For both versions I got this:

Msg 102, Level 15, State 1, Line 26

Incorrect syntax near 'GO'.

"None of the above" was not an option so I knew something was off...

Did...

Ugh, I knew I was going to get this wrong as soon as I read the answers. :rolleyes:

The only thing NOEXEC tells you is that your code compiles. ...

Nevermind...

(miss-read the post I was commenting on)

Toreador (3/31/2014)

---

victoria_e_wood (3/31/2014)

---

In my opinion if the user was in fact a sysadmin why would you assign him or her rights over a database, they would automatically have rights over...

While the question provided scripts...

Hmm, I'm surprised how many people are complaining about this question.

The answer depends on the server role memberships of the login.

Since no information provided regarding the login's server...

Sean Lange (3/27/2014)

---

Nice question about a basic concept that many people don't understand. Given that at the time of post there are 30% wrong answers it seems this is something...

J DBA (3/26/2014)

I think this statment at the end of the second paragraph indicates that the script was run in the right context...

Therefore,...

Toreador (3/26/2014)

---

Nope, based on the preamble

first confirming...