Total CPU physical and logical

Total RAM

Total Drives not partitions

paste table script as well as trigger and indexes if on this table

select st.text,sp.* from sys.sysprocesses sp

cross apply sys.dm_exec_sql_text(sp.sql_handle) st

where sp.cpu >...

How many processors in a server , did u set the max_worker_thread,OS version 32bit or 64bit,All databases are on different HDD or drive not partition

select st.text,sp.* from sys.sysprocesses sp

cross apply...

If the SQL Server Browser service is not running, you can still connect to SQL Server if you provide the correct port number or named pipe. For example, you can...

MSDTC use for distributed transaction so its best to use a specific drive and i dont think you can use same disk for SQL instance binaries

if you define qurum drive...

drop the Disk from cluster if you can connect ,otherwise tell to your SAN administrator to back that drive and again assign with new LUN number to the server

Regards,

Syed Jahanzaib...

can you prove this?

Read this page from microsoft,you hit and trial people,you people have limited knowledge i think so

http://msdn.microsoft.com/en-us/library/ms165724(v=sql.90).aspx

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE...

I think I guess you are taking log backup with tail option,if this option check then database is come to restoring state,check this option also

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP...

mention your sp code

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

How much Processors and RAM allocated for VMWARE,which type of drives you have ,is there any RAID Level or SAN or NAS drive

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA...

db_dlladmin is available in the User_Mapping windows of a user in the security on a particular database

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP...

Indexes are created already ?

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

Start the SQL Server Browser service from the

CONTROL-PANAL ->Administrative Tools -> Services

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog

http://www.aureus-salah.com

select * from table_name where column='20110101'

mention columns which you have required in the selection and mention index scripts also

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP | OCE...

MetaData should be MS SQL Server 2005 or Later because SQL Server 2000 is not a schema base database

and use this new JDBC driver 2.0 by Microsoft

http://www.microsoft.com/sqlserver/2005/en/us/java-database-connectivity.aspx#performance

Regards,

Syed Jahanzaib Bin Hassan

MCTS...

I didnt deny the installation of binaries,I was talking about Native Client only,How many Native client drive on your windows System

Regards,

Syed Jahanzaib Bin Hassan

MCTS | MCITP | OCA | OCP...