Step 1. Find out if any missing indexes on the Table which you are using. Create important missing indexes.

Step 2. Find out queries taking more time on specific Table and...

Grant Execute...

http://msdn.microsoft.com/en-us/library/ms345484.aspx

HTH

Looks like datatype in the destinoation column is having some issue. I suspect it would be date field.

HTH

Are you getting different plan for this query only and every time? Have you tried other query to check plan in app and sql?

It depend on the query(what you are executing?). But definitely if table is having index and view is having huge data and you run a query without index on views...

Check this out:

http://www.brentozar.com/sql/picking-a-dba-career-path/

You need to also take care of LOGINS/USERS.

Also make sure you do have backup of all the databases including system dbs.

There are many things to consider e.g. the additional drive is local drive, SAN, if SAN how it has designed etc.

Surely you can shrink datafile if there are no options left. No disk space might cause database goes into suspect mode. Else check if you do have space on...

I am facing the same issue to empty .ndf for tempdb. SQL Server 2005 SP4.

It's SP4 so solution SP3 will be eleminate.

It's tempdb and recovery is simple also getting value...

I was also having the same issue; following link is useful:

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/04/19/db-maintenance-rebuild-index-task-always-fails-on-operationsmanagerdw-scom-database.aspx

There is no need to reindex OperationsManagerDW.

http://blogs.technet.com/b/kevinholman/archive/2008/04/12/what-sql-maintenance-should-i-perform-on-my-opsmgr-databases.aspx

HTH

Yes, error it self clearly indicates that "insufficient disk space" autogrow is trying to expand the LDF file by 10% and unable to do due to space issue.

As a solution:...

Check the following link:

http://msdn.microsoft.com/en-us/library/ms177443.aspx

HTH

If database size is small than I prefer to create the replication setup again during off pick hours. Which will ensure you that all things are set up correctly and...