|
I think I might steal that one.
|
|
|
|
|
I was thinking
UPDATE User SET Clue=@Clue WHERE Clue IS NULL
|
|
|
|
|
that one would throw a SystemOverloadedException
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Amazing way to answer Luc..
You stole the show...
|
|
|
|
|
please let me know the difference b/w clustered and non-clustered index... in sQL server in
simple language....eventhough i searched in google im not clear abt the exact diff
and in which scenario use these indexes...(clustered and non clustered)
|
|
|
|
|
Basically the main difference is that both are B-tree indexes but clustered index causes the data in the table to be sorted based on the indexed columns. This is why a single table cannot have multiple clustered indexes. Nonclustered index is like an index at the end of a book. Entries are sorted and there are pointers (page numbers in book) referencing the actual place for the data.
Have a look at this: Nonclustered Index Structures
[^]
Regards,
mika
|
|
|
|
|
Mika Wendelius wrote: data in the table to be sorted
Don't you mean sorted and STORED using the clustered index, I think that is the most relevant part.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Yap, exactly. I was thinking the table as a permanent object but it's a good idea to clearly point that out. Thanks.
|
|
|
|
|
It's been a while since we saw you here, welcome back.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you Mycroft
Yes, it's been a really busy couple of years.
I noticed that you've been a 2010 MVP . Congratulations (sorry that this comes so late!)
|
|
|
|
|
Guys I have joke;
who know what is the opposite of 'Safe'?
Help people,so poeple can help you.
|
|
|
|
|
Walking down Balham High Street at 2.30 in the morning in a pair of slingbacks?
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC League Table Link
CCC Link[ ^]
|
|
|
|
|
|
Not if he overruns it (other than first).
|
|
|
|
|
Posting messages like this in the Database forum.
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Makes perfect sence. A joke Database
He wanted to be sure that the joke would be in the database
All the best,
Dan
|
|
|
|
|
|
Sir, you shouldn't keep serious all the time. a joke after a serious discussion wont kill any body
100
Help people,so poeple can help you.
|
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: Guys I have joke;
Well take it to the lounge where it will get treated properly.
I must get a clever new signature for 2011.
|
|
|
|
|
thank you for doing this, Alen.
Help people,so poeple can help you.
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: Guys I have joke;
who know what is the opposite of 'Safe'?
first of all Is it safe?[^] posting jokes in this forum & also asking a question about that
|
|
|
|
|
Sir, what is your problem with that?
making a joke in the end of a working day is also necessary.
100
Help people,so poeple can help you.
|
|
|
|
|
Ali Al Omairi(Abu AlHassan) wrote: Sir, what is your problem with that?
Nothing dude, but what about the lounge where many people there....also it's not a right place to post jokes. That's it.
Anyway come to lounge if you have interesting things to post. Cheers.
|
|
|
|
|
thank you for doing this, Alen.
Help people,so poeple can help you.
|
|
|
|