In the question: "If I do not want the cardinality estimator to be used," that crystal clear means to disable this feature.

but the answer states that you will run the...

+1

Raghavendra Mudugal (4/28/2014)

---

Thank you for the post,SJ, good one.

With the help of this link http://msdn.microsoft.com/en-us/library/dn553124(v=sql.120).aspx, i was able to pick the right answer, most of the time i took in...

Hugo Kornelis (4/25/2014)

---

I never had to do this, but I still managed to zoom in on the right answer. Probably something I read or heard somewhere, sometime.

For people who prefer...

Stuart Davies (4/25/2014)

---

Nope that's changed 93% of 30 answers now -...

Did that one before in a testing system, so I knew it 🙂

Steve Jones - SSC Editor (4/24/2014)

---

The 2014 BOL updates have lagged a bit and I suspect there are doc issues. There are 8 in 2014. If you see it documented...

and I got it right 😛

Had to do some quick searches to get it right, thanx.

MyDoggieJessie (4/21/2014)

---

Darn. Missed that one. Had it stated "In 2014 can you run SQL Server in your existing data center and store data files for a database in the...

Easy one!

Yes, it should be 😉

Carlo Romagnano (4/18/2014)

---

In SSMS 2008 r2, results could be copied only in grid mode or if the amount of the text is less than 2MB. If text is more than...

Igor Micev (4/18/2014)

---

This is a great new feature in Sql Server 2014

Example (http://msdn.microsoft.com/en-us/library/ee210585(v=sql.120).aspx)

ALTER SERVER CONFIGURATION

SET BUFFER POOL EXTENSION ON

(FILENAME = 'F:\SSDCACHE\Example.BPE', SIZE = 50...

+1