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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2008-06-19 : 11:06:44
|
| Hi, Can anybody please pass on script to find out highly used index in a table.I know that it's easy to find it in sql server 2005 but not in 2000, If anybody had a script which does this please pass on.Thanks in advance |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-19 : 11:46:05
|
| You will have to create one. It is very hard to find in SQL 2000 without running profiler. |
 |
|
|
|
|
|
To find highly used index