While SQL Server 2005 can do online index rebuilds, it requires that all TEXT columns be replaced with VARCHAR(MAX) columns. So all of your diary and unlimited character fields will have to be converted at the database level. BMC can't tell us if this will cause any problems or not in Remedy. My guess is that at the very least any new fields you create would still get the TEXT datatype since that's how Remedy forms the SQL statements. Since Microsoft will be getting rid of TEXT at some point BMC will probably get with the program on this but I don't think they have yet. We plan to do some testing of our own on this but haven't had the chance.
Chad Hall (501) 342-2650 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kevin Gallagher Sent: Wednesday, August 01, 2007 8:44 AM To: [email protected] Subject: Re: SQL Question - Fragmentation In short adding, modifying, and deleting data causes fragmentation. I googled it to see what I could come up with. Here is a pretty good link on managing fragmentation: http://mssqltips.com/tip.asp?tip=1165 --- "Dudley, Joelie" <[EMAIL PROTECTED]> wrote: > Question for you SQL gurus out there. > > MS SQL 2000 - what makes database tables get fragmented? Is it > normal > for this to occur? > > Any help on this would be greatly appreciated as our Remedy SQL > database > has hundreds of fragmented table. > > Thanks, > > Joelie Dudley > Application Developer > 555 Walnut Street > 7th Floor, Forum Place > Harrisburg, PA 17110 > Phone: (717) 772-8143 > > > ________________________________________________________________________ _______ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > ARSlist:"Where the Answers Are" > K. R. Gallagher Mailto: [EMAIL PROTECTED] http://www.krgallagher.com ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" *************************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. **************************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
