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 |
|
Jay123
Yak Posting Veteran
54 Posts |
 Posted - 2010-04-14 : 07:32:26
|
| Where is the option to specify new index in SSMS.I was watching and practicing sql simulations when i realised i can create index useing t-sql but i dont know how useing ssms.the simlation is saying that a table is performing poorly and it has a non clusterd index. it says create a new index useing the new index dialog box. but the simulation Start already in the new index dialog box. and i dont seem to be able to find it.Right clicking revels a option saying full-text index but it is different to the video. Thanks |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-14 : 07:41:08
|
| Right click on the table, and select Design. In the window that opens, right click on one of the column headings in the list, and select Indexes/Keys. That will open the indexes window for that table. Click Add, and populate the details in the list on the RHS.------------------------------------------------------------------------------------Any and all code contained within this post comes with a 100% money back guarantee. |
 |
|
|
|
|
|
Createing new index useing SSMS (2005)