John W. Colby
jwcolby at colbyconsulting.com
Mon Oct 11 06:45:21 CDT 2004
Well, I kinda knew the answer to that one question. How bout the others? I already went through this when I added an autonumber index. It rebuilt the table then, why is it doing it again? This table is huge and rebuilding it is a 48 hour process. Do I have to go through this every time I add a field to the table? This is a bit ignorant don't ya think? John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Haslett, Andrew Sent: Sunday, October 10, 2004 11:39 PM To: 'dba-sqlserver at databaseadvisors.com' Subject: RE: [dba-SQLServer] Warning, the table As with most things, probably better explained in BOL. It has to do with the default comparison of NULL's. Search BOL for ANSI_NULLS specifically the topic NULL COMPARISON SEARCH CONDITIONS -----Original Message----- From: John W. Colby [mailto:jwcolby at colbyconsulting.com] Sent: Saturday, 9 October 2004 1:21 AM To: SQLServer Subject: [dba-SQLServer] Warning, the table When I try to add a field to the table it gives me a "Warning, the table was created with Ansi Nulls OFF. The table will be recreated with Ansi Nulls ON". I know from experience that this causes the db to go off for days at a time rebuilding the table. What the <expletive deleted> are ansi nulls and why was the table created with it off? Why do I need them now? Is there any way to prevent this and yet still be able to add a field? Is there any way to allow setting ansi nulls on but not "rebuilding the table"? I already added a field (an int identity) and it told me it was rebuilding the table for that field. Why is it having to rebuild the table again. This is getting rather silly especially since it takes literally days to rebuild the table. John W. Colby www.ColbyConsulting.com Contribute your unused CPU cycles to a good cause: http://folding.stanford.edu/ _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com