All performance benchmark should be conducted on the same hardware, if possible.
I have ESXI at home  with installed VNext 1.5 and 2016SP1.  I will allocate the same resourcers for...

Here is article with exactly the same case study

https://blogs.msdn.microsoft.com/psssql/2010/09/28/case-of-using-filtered-statistics/

It does not have deep technical explanation, unfortunately. Respect to author of question.

Finally interesting question here. I got it due research.

Also

CREATE unique index IX_lang ON [dbo].[languages](language) WHERE language = 'deutsch'

lead indirectly to filtered statistics and desired query plan

Thanks.

Scott Coleman (7/26/2016)

---

What I read in the middle of that page:

If the length of an output column of string data is...

Just checked

1. MSDN

https://msdn.microsoft.com/en-us/library/ms141706.aspx no mentioning about truncation.

2. VS Studio 2015 & 2016 project. Behavior as expected - by default component configured to fail. Test proved that.

Where is...

Jacob Wilkins (1/11/2016)

---

I understand your reasoning, but that's not the correct scope for the OR in that English construction.

The construction "X, whether Y or not-Y", is equivalent to "IF (y...

GilaMonster (1/10/2016)

---

Question: Dropping any index on the table, whether it is used by the query plan or not.

MSDN: Dropping an index used by the execution plan.

Dropping any index on the...

Here is something wrong with question.

I picked

"Dropping any index on the table, whether it is used by the query plan or not"

According to MSDN https://msdn.microsoft.com/en-us/library/ms181055.aspx

one of reason to...

sumeet.zagade (7/31/2013)

---

Hi,

I got he same error in WS 2012 with IIS 8.

From add role and features, enable everything for .net framework 3.5 and 4.5.

under "WCF Services", check the box for...

So simple question and I was wrong with answer "D" ?!

Give me my point back !

PS I'd be nice if someone checks QotD questions before their appear....

One more time stupid question... Does anybody make review before its became published ? Also it would be nice to have possibility dismiss results for this one.

Koen Verbeeck (10/30/2012)

---

Konstantin Reu (10/30/2012)

---

I think the question is not ready to be published. Description is not clear and have many mistakes like mentioned term "SalesGoal" but I did not...

Hugo Kornelis (10/30/2012)

---

First: It does. The CREATE TABLE script does not include a NOT NULL constraint, so the columns are all nullable.

Second:...

I think the question is not ready to be published. Description is not clear and have many mistakes like mentioned term "SalesGoal" but I did not find it anywhere 😀

Next...

neprosto (7/10/2012)

---

I've scheduled exam on 19 jul. Now i am seeing cbt nuggets for 70-461 - very very simple. I guess that 70-461 is simpler than 70-433.

Can anybody...