patrickmcginnis59 (12/24/2012)

---

Let's assume there is no clustered index on this table. This makes it a heap, meaning the rows are not physically written to disk in any particular order. When...

roger.plowman (12/24/2012)

---

I always liked the library analogy.

The clustered index is how the books are shelved (usually by Dewey Decimal number), the non-clustered indexes are the index cards in the card...

Thank you.

hakkie42 (12/24/2012)

---

Ok, so in other words you're saying a clustered index means that the physical data is stored in index order, so e.g. binary searches are possible.

A nonclustered index is...

Thanks much.

Sure, but if you're loading the old data into the new tables, you can just declare normally and once you've added the data, it'll continue from the highest value. I...

... or you could simply use the built-in functionality in SSMS. Highlight the table name, and hit ALT+F1. It will give you all kinds of useful table metadata, including:

- Column...

We configure tables to start with a higher seed value when creating a new database for an existing Customer with the intention of loading their older data into the new...

Isn't the very point of posting on a forum so that you can share your thoughts with others? No...

I have to say the question and answer options provided were not clear,...

Good reading, thanks. The NoSQL movement is more than 20 years old? Didn't know that...

cdonlan 18448 (8/14/2012)

---

I think it's worth repeating that there is nothing wrong (in general) with making a mistake, it's how we learn.

...

If you sincerely want to improve yourself then...

Thank you for your thoughts, and for the recommendation, I...

tommy_o_is_my_name (8/6/2012)

---

It really depends on the people involved, their relationship with each other and their understanding of each others personality. It's not what you say it's how you say it...

Thank you, appreciate your saying it.