GilaMonster (3/20/2012)

---

tilew-948340 (3/19/2012)

---

- "Rowlock" locks the row being updated and (what I think) releases the lock once the update is done.. It loops for the 7500 rows to be updated,...

paul.knibbs (3/19/2012)

---

This is one of those questions that I answered randomly because I wanted to see what the answer was...would have been nice to get a slightly more in-depth explanation....

I found the answer rapidly as I was smart enough 😀 to find the error

Because I know that it would not take me more than few seconds to realise that...

Hugo Kornelis (3/13/2012)

---

...

The view above allows people to add personnel into the Marketing department, or to update a row to transfer someone from Sales to Accounting. The WITH CHECK option...

I am not sure to...

nice and easy question since it is mostly what I am doing now 🙂

I would not have said that some time ago: I deleted a row in a view and...

paul.knibbs (3/5/2012)

---

Good thing I actually looked up the T-SQL definition of this before answering, because I wasn't sure if it should include the endpoints or not...the actual English word "between"...

+1

Thanks

For the first time since I am a member, I am happy to say that it was an easy one 🙂

Thanks!

Exactly what I was looking for: 2397 types of...

I finally understand why I see the N' in some queries and why I got "H e l l o " instead of "Hello" (with space between chars) when the...

Thanks very much for the explanation Hugo. It certainly help to understand the difference between point-in-time restore and a restore from simple backup

Very, very much appreciated ! thanks again

dawryn (2/22/2012)

---

Is there a correct answer at all :hehe:

In theory you can't set or maybe you can, depends on which article you read.

In practice you can set and new database...

SQLRNNR (2/21/2012)

---

GilaMonster (2/21/2012)

---

SqlMel (2/21/2012)

---

Easy question. Thanks!

It's now down to 2% 🙂

Nils Gustav Stråbø (2/21/2012)

---

Good and easy question. Thanks.

I'm surprised that 21% believes that you can do a point in time...

MCM, MCITP, MCTS... All three levels of certification needs time, money and surely "show that you have some knowledge about a product, even if it's something you memorized for...