Databases do tend to grow over time as you put more data into them.

What is the problem with it growing? are you running out of space?

run DBCC CHECKDB on the database to check for any errors.

DBCC checkdb WITH ALL_ERRORMSGS , NO_INFOMSGS

http://msdn.microsoft.com/en-us/library/aa258278(SQL.80).aspx

Only the Enterprise edition of SQL Server offers peer-to-peer replication.

Are you running enterprise?

no

What do you want to learn? what aspects of the Job do you enjoy?

It seems like you have worked as a ETL developer, database developer, software developer and a...

I mean , is the SQL service running under a Domain Account or a Local System Account

what sort of accounts are the SQL servers running on ?

what sort of accounts are the SQL servers running on ?

Though i usually avoid EAVs this seems like a case where you could have one table to hold all the attributes.

for example

you could have one table with the shape...

What sort of information about the shapes do you need to store?

For a large amount of updates i find the most effiecnt way is to put the updated value in a lookup table and then do the update using an Update...

Gift Peddie (3/23/2009)

Well but when you need to store Greek one of the most complex...

Collation does not affect how the data is stored, only how it is compared and sorted.

Are you using a UniCode column type (nChar or nVarchar)?

Are you using the prefix N...

Add a Maintenance Clean up task to your Maintenance plan, with this you can select to delete old backups that are over a certain age.

Run this nightly to clean...

It is really hard to give specific advice as lot of the answers really depend on what you are using the database for, how the application code has...