Sorry for taking this thread out of the scope... (this is nothing to do with the QToD's objective, but was playing around and kind of stuck with this...:Whistling: )

Considering the...

@tom - Glad to be help. 🙂

@jim_k - I am not sure if this can be an advantage, but to my knowledge -

Say the 1TB...

Thanks for the question Lokesh-ji, (so simple and yet so much to consider).

(actually i did not focus on the collation but saw the count(*) and then I chose 6 :hehe:...

Thank you for the question, was nice and good brain exercise on Sunday 🙂

Got the answer wrong and I kind of tricked myself into it with the INIT as it...

Thank you Hugo, the details what I had, like Alex has said possibly I have taken way too far. I need to be more consistent in my saying, as I...

demonfox (9/13/2012)

---

Lokesh Vij (9/13/2012)

---

An easy one for Friday!

I love using Rollback [after specified time].....to warn developers to log-off from the database otherwise they will automatically be logged-off after specified...

Awesome, Great question. 🙂

Considering there is one transaction which is still not committed ,If executed the below command then

-- #1

ALTER DATABASE LOCALWORK SET OFFLINE WITH NO_WAIT

-- RESULT

Msg 5070, Level 16,...

Hugo Kornelis (9/13/2012)

---

Finally, I can give you one example where this knowledge can be useful: when you have a co-worker whose idea of fun it is to change the batch...

Thank you Kenneth, Interesting one 🙂

I have selected the wrong answer, thinking either you change the script or query option, the change is compulsory. And later i read the question...

emiddlebrooks (9/12/2012)

---

I'm also a bit confused why peppers is at the end. If lowercase p is before uppercase p, which I knew it would be, why was it at the...

may...

Toreador (9/12/2012)

---

That puzzled me as well, so I did some more testing and found that

"final" comes before "initial"

"eleven"...

vk-kirov (9/12/2012)

Well, I should note that nouns ending with the letter S are considered plural in English. But here we deal with a Latin collation, and the Romans had their...

(to my knowledge)

Because here the "peppers" is plural. Of-course the...

Nice one, 🙂