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 |
|
JaybeeSQL
Posting Yak Master
112 Posts |
 Posted - 2012-05-02 : 04:30:16
|
| Is there any way to determine this WITHOUT creating a sproc? IE, is there a Select statement that I can run to get fragmentation levels for all indexes on a particular table/db/server? Thanks all |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-05-03 : 05:47:41
|
| Appreciate the straight answer! |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-03 : 07:01:18
|
quote:
Originally posted by JaybeeSQL
Appreciate the straight answer!
Just out of curiosity, what wasn't straight about the same answer in this thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=174035 |
|
|
|
JaybeeSQL
Posting Yak Master
112 Posts |
Posted - 2012-05-03 : 09:02:23
|
| Note to self: check existing posts for answers before starting threads anew. :) |
|
|
|
|
|
|
Index fragmentation