james.of.rivendell (6/19/2013)

---

None of the answers is correct. Choose is a 2012 function, so it doesn't work in 2008 R2, which is the *assumed* SQL version here. Nowhere in the question...

Got it wrong because I confused the first column of the sample data set to be the empid , instead of the department ID.

Easy one, thanks.

Interesting question Hugo, thanks!

enajjar1910 (6/9/2013)

---

Passed 70-461 today. Have a project to establish a BI warehouse. What would make sense to take as the next exam.... 70-462 or 70-463? Can...

I also get that. Hugo, what is your collation and...

Tab Alleman (6/7/2013)

---

Palash Mitra (3/7/2011)

---

Hi,

On doing some web searches I have come across suggestions to increase TypeGuessRows doing registry edit.

Ref: http://support.microsoft.com/kb/281517

That KB article says it only applies to...

Easy one to start the week, thanks.

Interesting question, thanks.

Easy one, thanks Ron.

Danny Ocean (6/4/2013)

---

Really easy one. Just look the first if condition, it gives result as 'Statement1 : Not null'. Now only Option 2nd having this one. I don't need to...

Easy one, thanks Steve!

4GB is not a lot of RAM, especially since Windows has to have a piece of it as well.

You know give a VM 1GB of RAM and it will still...

Nice question, thanks.

I'm pretty sure the first answer could be correct as well...