Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sriram21
Starting Member
1 Post |
 Posted - 2005-04-11 : 02:59:31
|
| Hello,In migration from sql 6.5 to sql 2000, please let me know the replacement of 'segment' present in sysindexes table. What is the suitable replacement for segmap column of sysusages in Sql server 2000 ?Thanks in Advance.Sriram |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-11 : 12:10:22
|
| Filegroups. Look up 'segments' in Books Online. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-11 : 18:23:10
|
| In fact, read everything you can in Books Online regarding indexes and pages. The storage mechanisms in SQL Server have changed significantly since 6.5; it's fair to say "forget what you already know", because it really does not apply anymore.There's also sections on "What's New" and "SQL Server Architecture" that have more details. You should also look at "compatibility" entries and study them. Some commands and system tables also have level entries, "Level 1" includes features from 6.x versions that have changed significantly and should be studied. |
|
|
|
|
|
|
Replacement for segment in SQL 2000