If he has just copied objects from user database to master database then delete those objects manually and after that make use of shrinkfile command.

MJ

Check indexes fragmentation and make sure statistics are updated.

MJ

Free,

You can't specify a filegroup for a transaction log file.

MJ

From central forum itself:

First:

You can write union all then write union query order by the primary key. you can see the difference.

select primarykey as Primarykey,* from T1

union

select primarykey as...

Ignore Task Manager

If you have an awe enabled SQL Server instance, do not rely on Task Manager to display memory usage as it does not show the AWE memory a...

Check windows event viewer application logs and see if it helps.

MJ

Its an option under Create Index in sql 2000:

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

MJ

Resolve your performance counter problem:

http://support.microsoft.com/kb/300956

HTH!

MJ

Run profiler and try to track it from there.

MJ

Better use a script to cature rowcount of all user tables in a central table for few days and then compare the difference in rowcount. Those with too many row...

Any functions referenced in an indexed view must be deterministic; deterministic functions return the same value each time they’re invoked with the same arguments.

I think your function is not deterministic...

You can make use of quest product "litespeed" or any third arty products for reducing the backup time.

http://www.quest.com/Quest_Product_Demos/LiteSpeedforSQLServer_demo_043007/chap00.htm

MJ

tblleadstatus and tblsalesstage

MJ

Are you making use of aliases under SQL Server Configuration Manager?

MJ

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

MJ