I want the CHTM format. 😀

Eirikur Eiriksson (9/30/2014)

---

Thank you for the question Amit.

Given options of 0,2 and 20 with the set's cardinality of 20 makes this kind of obvious; the granularity of syscolumns is {object,column},...

I got it "right" by eliminating 0 and 20, but the answer is incorrect! When I tested the query, I got 5 values in master and I got different numbers...

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

Igor Micev (5/21/2014)

---

Sean Pearce (5/21/2014)

---

The question is not quite right. Fragmentation can be removed by running this because the table is rebuilt.

Your...

Nice questions! I got it wrong, but learned a new way of changing the persisted attribute. Dropping and recreating should have worked too, but this is probably easier.

It depends is my...

Hugo Kornelis (4/2/2014)

---

I like the recent series of questions with some backstory. Not the strongest stories, but enough to add a nice touch to the QotD.

A resultset is being returned...

Easy one, even though its april fools day. 🙂

+1, but the answers "depends" on Cascades and nullability. This i completely correct (even if I don't like it)

CREATE TABLE dbo.a

(id INT PRIMARY KEY, NAMN VARCHAR(19))

CREATE TABLE dbo.b

(

id INT NULL,...

This question was almost too easy, had to read it 5 times to try to find any pitfalls.

Easy question, I've been in this situation a couple of times. 🙂

Wow, interesting question! 😀

Easy, but important question! Thanks

Well, it depends:

sp_updatestats updates only the statistics that require updating based on the rowmodctr information in the sys.sysindexes catalog view, thus avoiding unnecessary updates of statistics on unchanged rows.

That is,...

Paul White (11/3/2013)

---

Well it might do,...