Reallocating text pages after updating column to null 
Author Message
 Reallocating text pages after updating column to null
Anyone know an easier way to recover unused text pages after setting
the column to null?

The only way I know is to bulk copy the entire table out, truncate or
delete the rows, and bulk copy it back in.

Any other suggestions/ideas?

Eric

P.S.  Running ASE 11.5.1 on AIX



Sun, 19 Jan 2003 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. column is null vs. column = coalesce(@var,null)

2. How to ensure if column A is null, column B has to be null

3. How to change a NULL column to NOT NULL column

4. Text Field page wasted after set to NULL

5. NULL Column structure on a page.

6. Substitute Blank for Null Text Column

7. Text columns and nulls

8. JDBC, SQL Server & null Text columns

9. Need help BCP'ing NULL TEXT column values

10. SQL Server Text column comes back as NULL when it has a value

11. Paging through long text stored in single row and column

12. Paging through long text stored in single row and column


 
Powered by phpBB® Forum Software