As I am not a big fan nor a current user of the Data Warehouse or ETL; so I had to do some researches about it to get the correct...

Nice tricky question, definitely some here will fall in it (especially the first choice) 🙂

Good question & nice idea, thanx.

Well, didn`t know that, good to know new info.

There is; the last choice: 1,1,1,1,40,1,10,2,1

But I guess...

Guessed it right although never used SSIS until now in production.

+1 (Same)

+2

L' Eomot Inversé (10/3/2013)

---

SQLDCH (10/3/2013)

---

L' Eomot Inversé (10/3/2013)

---

Nice question.

I find it quite surprising that 58% of answers so far were wrong; and even more surprising that nearly half of the...

Good question, had to make same researches; good to know some new info.

Also you may check this link it has some useful info about "Hekaton":

http://blogs.msdn.com/b/data__knowledge__intelligence/archive/2013/04/21/hekaton-and-bwtree-makes-the-next-version-of-sql-server-super-fast.aspx

Got it wrong :hehe:, but no problem; definitely learnt something new.

Easy.

Thanx for the easy question & easy point; didn`t have to run the code this time 😉

Although I was pretty sure that this is another tricky question and my answer will be wrong when I pressed Submit button; but surprisingly it was correct 🙂

exec @variable; hmmm...

kapil_kk (9/23/2013)

---

While using SELECT it will give the output in a commented lines while using EXEC it gives the error :crazy:

declare @var Varchar(1000)

set @var = '-- /* select ''Samith'' name

...