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 |
|
bkpgamble
Starting Member
30 Posts |
 Posted - 2006-11-02 : 04:32:30
|
| Were if anny can you se wenn an index was last reorganized.? |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-11-02 : 04:39:01
|
| Don't think that you can, although if you are using a Maintenance Plan and have the Reporting thingie turned on then the output from that may tell you.DBCC SHOWCONTIG will tell you if it is fragmented, and thus can be used as a guide to whether it needs doing or not!Kristen |
 |
|
|
|
|
|
Reorganize timestamp ?