Viewing 15 posts - 481 through 495 (of 551 total)
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 18, 2012 at 12:49 am
@tom - Glad to be help. 🙂
@jim_k - I am not sure if this can be an advantage, but to my knowledge -
Say the 1TB...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 18, 2012 at 12:26 am
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:...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 17, 2012 at 11:41 pm
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 15, 2012 at 11:43 pm
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 14, 2012 at 11:29 pm
demonfox (9/13/2012)
Lokesh Vij (9/13/2012)
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 14, 2012 at 1:50 am
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,...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 14, 2012 at 1:07 am
Hugo Kornelis (9/13/2012)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 13, 2012 at 3:48 am
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 13, 2012 at 12:35 am
emiddlebrooks (9/12/2012)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 13, 2012 at 12:01 am
Alex Fekken (9/12/2012)
Taking a atep back, why should the sort order depend on either SOUNDEX (especially when case sensitive) or gramnatical interpretation at all?That sounds like total atupidity to me.
may...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2012 at 11:33 pm
Toreador (9/12/2012)
Alex Fekken (9/12/2012)
I don't get it either: so 'feet' would come after 'foot'?
That puzzled me as well, so I did some more testing and found that
"final" comes before "initial"
"eleven"...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2012 at 6:21 am
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...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2012 at 6:10 am
vk-kirov (9/12/2012)
I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
(to my knowledge)
Because here the "peppers" is plural. Of-course the...
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2012 at 4:20 am
Nice one, 🙂
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
September 12, 2012 at 4:03 am
Viewing 15 posts - 481 through 495 (of 551 total)