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 |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2006-03-31 : 14:41:14
|
| First, 2005 seems to have a good reindex capability. At least, I shouldn't need to write a stored procedure to do it as I did in 2000.I've installed the standard edition. I heard somewhere that only the Enterprise edition had the capability of keeping the INDEXES / Tables Unblocked during reindexing, and yet... there's a checkbox in my (2005 standard edition) reindex dialogue: "Keep Indexes Online during Reindexing"...Hmmmmmmm.... Can anyone confirm this. Any reason not to check this option?Sam |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-04-03 : 09:44:42
|
| I seem to remember Paul Randall saying something about this ... might be worth a search here filtering on hist ID/posts?Kristen |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-04-03 : 11:20:22
|
| It does say in the Books Online that it's an Enterprise online function, and I'm fairly sure that a sample MSDBA certification test has a question relating to this and the answer is that you have to upgrade to Enterprise.-------Moo. :) |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2006-04-03 : 11:50:24
|
quote:
Originally posted by mr_mist
It does say in the Books Online that it's an Enterprise online function, and I'm fairly sure that a sample MSDBA certification test has a question relating to this and the answer is that you have to upgrade to Enterprise.
And yet... the checkbox is there. Standard edition.Or is it just me? |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-04-04 : 03:49:16
|
quote:
Originally posted by SamC
quote:
Originally posted by mr_mist
It does say in the Books Online that it's an Enterprise online function, and I'm fairly sure that a sample MSDBA certification test has a question relating to this and the answer is that you have to upgrade to Enterprise.
And yet... the checkbox is there. Standard edition.Or is it just me?
I suppose the question is whether or not the checkbox actually does anything? Or if you can execute a rebuild with the online option and it does what it says on the tin.-------Moo. :) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-07 : 05:02:47
|
| the online reindex just means you can do your reindex and others can still query those tables with indexes that are not "yet" affected by the operation, so it's not an offline process anymore but it remains to be seen if it holds that promise...so sam, you still need to create that sproc :D--------------------keeping it simple... |
|
|
|
|
|
|
Keep Index Online during Reindexing - Standard Ed