IMO - This is another 5 STAR question.

It was simple, elegant, and without a typo in the code, question, or answers.

It has sparked three pages of discussion and debate already...

da-zero (12/7/2010)

---

Considering that you can have up to 1023 (max columns in a table -1)...

He left out the word "key" in his question, you left the word "index" out of your rebuttle.

😀

GilaMonster (12/7/2010)

---

Another phrasing problem with the question - the maximum size of an index is not 900 bytes. The maximum size of the key columns is 900 bytes. The index...

Not certain what you mean, the correct answer was clearly "16 key...

I understand that. My experiance with this feature in the past has taught...

john.moreno (12/6/2010)

---

bitbucket-25253 (12/6/2010)

---

john.moreno

hmm I tested repeatedly on both 5K and 8K before submitting the question .. always produced the identical answers on all servers...

Are you sure you executed the first...

Do you mean...

This has been the expected behavior of this "feature" for the last 15+ years in my world.

Was usefull when data storage and query...

Nice question, actualy had to run the scripts to determine the difference the two inserts would have on the two selects.

My favorite thing about it was the lack...

Hugo Kornelis (12/6/2010)

---

2. The explanation does not mention how important it is to make ANSI_PADDING is enabled at the time the column is created. If it's not, the results are...

Sanjay, Some of the more creative minds...

:cool:I am giong to get my point I lost back!;-)

Am I being greedy?

BowieRules! (12/2/2010)

---

I am sorry for confusing you with insert option, I only included it here because I found it on another blog as a solution to the problem, which I...

:cool:I am giong to get my point I lost back!;-)