Please keep an eye on DISK free space as well.

Keep the MB growth to higher values somewhat like 100MB. Which will make sure that it creates less number of VLFs

Please have a look on the t-log usage. Verify that u got any t-log full error, if so follow these methods to overcome

1. Increase the t-log space

2. If AUTOGROWTH is...

Microsoft has updated only following stuffs in SP2

SQL Server Utility,

Data-Tier Application (DAC),

as well as integration capability for Microsoft Reporting Services with the Microsoft SharePoint 2010 Technologies

Try applying CUs...

Procedure to change the logon account for SQL Server service is as follows:

Start -> Run -> Services.msc -> Navigate to SQL Server Service -> Right click -> Properties

Go to tab...

There might be two reasons:

1. You might have accidently selected SQLServer Express edition for installation, which will not comes with SQL Server agent

2. While installing SQL Server, you might not...

Deciding on the database size is one of the critical part of database design. It involves following important factors:

1. Transcation rate on database (number of transcation)

2. Size of individual tables

3....

Please verify under what account publisher and distributor are connecting together, and make sure that password(if SQL login means) was not changed in recent past. If it got changed, please...

Table is a logical concept in case of RDBMS. but files are physical concepts. There will be no physical relation between tables.

Activity monitor is also the best tool to get performance related queries.

U can use in built report tool embedded into SSMS for getting various reports like

-> Top queries by...

For ur problem I can give you following solutions:

Recovery Model: Simple

1. Try to run the inserts/deletes on the tables in a batches of 1000/10000 (which ever is applicable in ur...

With microsoft all your SPs are superset of previous updates i.e SP3 contains SP1 and SP2.

If you apply SP3, that is more than sufficient. No need to apply SP1...

There may be multiple cases for this issue. To come for proper conclusion, please verify the jobs correspoding to this replication setup and make sure that they are running..not hung.

If...

You can try below sites

Books online from MSDN is best place for any SQL Server study

Few other sites that may help u are:

http://sqlis.com/

http://blogs.msdn.com/b/sqlrsteamblog/

U can try books...

You can download the SQL Server 2008 R2 enterprise trial version, which will have all features of enterprise editions for 180 days. As you mentioned your database size is 70+...