sqlserver

1. Action Points

1.1. surrogate key

1.2. Point 2

1.3. Point 3

2. Ideas

2.1. Idea 1

2.2. Idea 2

2.3. Idea 3

3. create table

4. sql server identity key

4.1. property

4.2. function

4.2.1. select into

4.3. surrogate key

4.4. maintenance

4.4.1. checkident

4.4.2. @@ident

4.4.3. ident_current(tablename)

4.5. avoids pagesplits

4.6. truncate will reset, delete wont

5. Problems

5.1. Problem 2

5.2. Problem 3