|
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?
| 
