Hi
Hope you can help me with some quick answers to these questions...
Does shrinking a db undo the index rebuilds?
Is the log truncated automatically after doing a full backup?
Ive a database with a 350MB table A (750K rows) and 90MB table B(3.5M rows), it comes in at 1.3GB on disk after backup / truncate/shrink/ index rebuild. The indexes are relavant i feel. I know that i should normalize table A, im hesitant as its a multiuser system critical to the business and simple makes me feel safe. Does the database on disk size flag to you as extreme considering the table structure?
Most of table A fields are nvarchar data type, data in these fields are less than 25 characters in practice almost always. Will changing fields to varchar datatype have an impact on performance?
Hope you can help me with some quick answers to these questions...
Does shrinking a db undo the index rebuilds?
Is the log truncated automatically after doing a full backup?
Ive a database with a 350MB table A (750K rows) and 90MB table B(3.5M rows), it comes in at 1.3GB on disk after backup / truncate/shrink/ index rebuild. The indexes are relavant i feel. I know that i should normalize table A, im hesitant as its a multiuser system critical to the business and simple makes me feel safe. Does the database on disk size flag to you as extreme considering the table structure?
Most of table A fields are nvarchar data type, data in these fields are less than 25 characters in practice almost always. Will changing fields to varchar datatype have an impact on performance?
Comment