BrainDonor (2/22/2012)

---

However, try this through the SSMS GUID. If I change 'Database Read Only' to TRUE from the Properties and then right-click on 'Databases' to create a New Database, it...

Based on a vague recollection, I answered that you can set it on the model database, but it won't affect new databases. I then found I apparently was wrong.

After reading...

tilew-948340 (2/21/2012)

---

It all depends on the interpretation on the answers (and your english or knowledge somewhere :hehe: ).

In my case, I got it wrong because I am doing only simple...

EL Jerry (2/21/2012)

---

Nice and easy. As someone said before, it's good to go back to the basics.

In your experience, how often have you seen DBs with Bulk-Logged recovery models and...

Andy makes some good points. The real question, of course, is: how to prevent falling in the success trap - or how to get out of it if you've already...

SQL Kiwi (2/17/2012)

---

Without an ORDER BY clause, the nested loops join has a WithUnorderedPrefetch attribute: pages needed for the RID lookup are fetched asynchronously (similar to read-ahead) and processed in...

SQL Kiwi (2/17/2012)

---

It isn't true and there are many ways to disprove...

SQL Kiwi (2/17/2012)

---

John Mitchell-245523 (2/17/2012)

---

Got it right, but I think the answer should be "it depends". On what? The selectivity of the data in Col [...] Therefore, in...

danielfountain (2/17/2012)

---

Hugo Kornelis (2/17/2012)

---

Nice, easy question - though I'm sad that as of this time, 8% of respondends got it wrong.

There is an error in the explanation, though. You can...

cengland0 (2/17/2012)

---

I immediately thought of using a hint to force the use of the index. Is that wrong somehow?

SELECT ID,Col

FROM FirstTable WITH INDEX(IX_Col)

WHERE Col =...

neprosto (2/17/2012)

---

Result of order depend on method to get result

1. Index seek

in this case relation engine use ROOT PAGE to start...

Nice, easy question - though I'm sad that as of this time, 8% of respondends got it wrong.

There is an error in the explanation, though. You can not avoid the...

bitbucket-25253 (2/15/2012)

---

SathishK (2/15/2012)

---

Hugo Kornelis (2/15/2012)

I got it right, for all the wrong reasons.

The script will not run, regardless of triggers, for two reasons:

1. The MERGE statements must be terminated with...

Sean Lange (2/15/2012)

---

I still don't quite get the point to be honest. It is kind of like saying "you can insert data into this table but this trigger is going...

cengland0 (2/15/2012)

---

The BOL reference also says:

I didn't...