Koen Verbeeck (8/13/2015)

---

OK, I didn't select the option with the in-memory table, because the sentence ends with only.

This made me believe the answer suggested that you could only create columnstore...

never used sp_spaceused for a VIEW. Learnt something new.

thanks for the question

+1

Thanks for the very interesting question. learning a lot.

When you...

ArnoKwetters (6/8/2015)

---

Strange. It looks to me that the primairy key index isn't disabled.

I scripted all 3 keys and noticed that only at the 2 non-primairy indexescript had an extra line...

good question, Thanks

I have selected two answers thinking that author gave the check boxes to select more than one answer.

nice question.. got it rite 🙂

Easy one

good question robert

please check the definition of the stored procedure

sp_helptext 'Test',

then you will understand

Thanks steve for the questions on LEAD and LAG

Nice explanation hugo

we set getdate() as default value for few of our date columns (not for all date columns), but never heard of keeping such high future date.

good explanation, thanks steve for QOD.

Truly, I have never done CMS to manager different servers. but to answer this QOD I have registered all the servers and run the backup script, script is executed on...