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 |
|
ramana123
Yak Posting Veteran
57 Posts |
 Posted - 2005-09-22 : 07:37:00
|
| hi all,can you tell me how many indexes(clusterd or nonclusterd indexes)can have my table in sqlserver2000.what is the next version of sqlserver2000thanksallrams123 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-22 : 07:42:37
|
| 249 nonclustered and 1 clustered indicesSQL Server 2005Are you new to SQL Server?MadhivananFailing to plan is Planning to fail |
 |
|
|
ramana123
Yak Posting Veteran
57 Posts |
Posted - 2005-09-22 : 08:16:34
|
| hi madivanan,i am not new to sqlserver..i know sqlserver ealier versoions than 2000.thats why i am asking regarding to sqlserver 2000.recently i heard about microsoft going to release the next version of sqlserver that why i am asking.any how thanks for your information.rams123 |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-22 : 23:15:57
|
Since you're new to SQL Server, open up Books Online, go to the index tab, and start reading.  I'm not kidding. It's one of the best things you can do.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
how many indexes can have my table