Thank you for the post, Carlo, really good one.

Just tried the creation part with FS where I assigned...

Thank you for the post, Steve, interesting one.

From the local_help, based on this I was able to select the choice which was right.

FILESTREAM data must be stored in FILESTREAM...

Thank you for the post, really good one.

(even after the proper analysis, I ended up "selecting" the wrong answer. I "guess" the problem lies between the keyboard and the chair....

Thank you for the post. Steve.

Orig: "Which of these aggregate functions does not ignore NULL values?"

Now: "Which of these aggregate functions does not exclude NULL values?"

When I loaded the Qtod,...

Thank you for the post,very good one. I went with eliminating the odds so remove two of them and you have the remaining one as the answer. Luckly the remaining...

Thank you for the post. Even though knowing the result, mind still looks for tricks.

(I had an item in my sql to-do list; "revisit cast and convert local_help page" from...

Thank you, Steve, for the post, very new one to me.

(luckily, this article from the home page http://qa.sqlservercentral.com/articles/Power+View/119430/ helped me to understand the PV. New year as began with new...

erwin.oosterhoorn (12/19/2014)

---

l.vignando (12/19/2014)

---

I tried on Sql 2005,

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Line 4

Must declare...

Thank you for the post, really good one. I had experience on this so it became to me to pick the choices.

+1

We use in all SPs.

Thank you for the post, really good one.

(How come the complete list of trace flags is not available in the msdn? Also found this link by Victor Isakov http://victorisakov.files.wordpress.com/2011/10/sql_pass_summit_2011-important_trace_flags_that_every_dba_should_know-victor_isakov.pdf,...

Thank you for the post, good one. My knowledge came back after selecting the wrong answer 🙂

Thank you for the post, really interesting one.

Neven knew this and had to guess and guessed it wrong. I used tvp but did'nt tried on multiple database level. Learnt interesting...

Thank you for the post. I tried it on sql 2012 and got 7 rows