By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

Quick questions About SQL Server 2000

P: 18
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?
Aug 26 '09 #1
Share this Question
Share on Google+
1 Reply


Delerna
Expert 100+
P: 1,134
The two datatypes are pretty much identical
except nvarchar can store unicode data
If you will not be storing multilingual data use varchar
Aug 28 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.