Hi,

Check the following link

How to manually rebuild Performance Counter Library values

http://support.microsoft.com/kb/300956/en-us

Regards

Check

http://www.simple-talk.com/sql/sql-server-2005/partitioned-tables-in-sql-server-2005/[/url]

Check the following links

http://www.sqljunkies.com/article/f4920050-6c63-4109-93ff-c2b7eb0a5835.scuk

http://sqlserver-qa.net/blogs/perftune/archive/2008/01/25/3285.aspx

Regards

Hi,

For SQL Server 2005 standard edition there is no limit.

Check the following link http://www.sqlservercentral.com/articles/News/comparisonofsqlserver2005editions/1768/[/url]

Regards

Hi,

Check the following link http://sql-server-performance.com/Community/forums/p/17320/101872.aspx

Regards

Hi,

Compare the execution plan.

You will see the which provide the best performance for your case.

Regards.

Hi,

Try to use the following queries

select * from sysperfinfo --SQL Server 2000-2005

or

select * from sys.dm_os_performance_counters -- SQL Server 2005

Check the following link http://msdn.microsoft.com/en-us/library/ms187743.aspx

If the installation instance of your SQL Server...

for CLR

EXEC sp_configure 'show advanced options' , '1'

go

reconfigure

go

EXEC sp_configure 'clr enabled' , '1'

go

reconfigure

go

-- Turn advanced options back off

EXEC sp_configure 'show advanced options' , '0'

go

for memory see Jeffrey post.

Regards

Hi,

Why move tempdb?

http://www.sqlteam.com/article/moving-the-tempdb-database

Working with tempdb in SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

Regards

Hi,

To enable CLR use Surface Area Configuration tool.

To set memory min and max check the following link[url= http://msdn.microsoft.com/en-us/library/ms191303.aspx%5D http://msdn.microsoft.com/en-us/library/ms191303.aspx%5B/url%5D

Regards

I have no idea,

I found some links may be the will help you

http://www.its.monash.edu.au/staff/systems/dsm/technical/cost-recovery/cost-comparison-das-san.html

http://searchstorage.techtarget.com/tip/0,289483,sid5_gci934858,00.html

http://www.microsoft.com/windowsserversystem/storage/dastosan.mspx

regards

Hi,

You are right. Unfortunately as 2000 dba I used to use this old sp.

Regards

Hi,

Also you can use the following sp

and check current_execution_status

Regards,

Ahmed

Hi,

Thanks For all of you.

Ninja's_RGR'us, Is 80000$C is good salary for a permanent job.

Regards,

Ahmed

Hi,

Just a point,

use charindex('.',proj_id) = 0 instead off not like '%.%'

and charindex('.',tblTest.proj_id) > 0 instead off tblTest.proj_id LIKE '%.%' for best performance.

Kindly,

Ahmed