Hany Helmy (8/28/2014)

---

On SQL Server 2008 R2, the view is being created without any errors, even though the compatability level for the db is set to 90 (SQL Server 2005),...

On SQL Server 2008 R2, the view is being created without any errors, even though the compatability level for the db is set to 90 (SQL Server 2005), then how...

Miles Neale (8/27/2014)

---

Really???? Wow, got it wrong but my answer was right.

Like please answer this true and false question:

The QOD and the answer for today was strange.

Answers(Please Select...

gbritton1 (8/27/2014)

---

The question asks, "What happens", yet one of the "correct" answers is that we need to change the variable and replicate lengths. At the risk of being pedantic,...

😀

Mighty (8/27/2014)

---

Not sure I see 4 correct answers (taking the "only" part of the first answer strict, so that any size other than 116 would not work), but 3 correct...

Yes, 😀

Ok, that was new for me, never encountered a case like this before, so definitly learnt somthing new today, thx.

Even after 8.5 Yrs. still usefull 🙂

Jo Pattyn (1/23/2006)

---

<A href="http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_042705.mspx">http://www.microsoft.com/technet/abouttn/subscriptions/flash/tips/tips_042705.mspx</A&gt;

Trace flag 2861 causes SQL Server to cache query plans for trivial queries that have a cost of zero or close to zero. SQL Server typically won't...

True.

😀

And I had fun answering this question, thx 😀

No one 🙂

Never used TABLOCK option with DBCC before, always using:

DBCC CHECKDB WITH NO_INFOMSGS, ALL_ERRORMSGS, TABLERESULTS;

DBCC CHECKDB WITH PHYSICAL_ONLY; -- Best Practice

So I had to read the documentation carefully, then answered correctly,...