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 |
|
d3ng
Yak Posting Veteran
83 Posts |
 Posted - 2007-07-12 : 22:12:18
|
| hi experts, I would to ask for a script on how to Select all the indexes/keys in a specific table, because I would like to check the value of fill factor for each indexes/keys then after that to update the "Fill Specification" > Fill Factor value. Because some of the tables in our database have indexes but the fill factor value is set to zero (0). Thanks in advance....!Darren Bernabe Blanco |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-12 : 23:24:41
|
| You can query sys.indexes. |
 |
|
|
|
|
|
Script to check Indexes/Keys