I have noticed that buffer cache hit ratio on sql 2005 instance showing 0 values why?
How do i take my instance in single user mode in sql 2005?
Any idea, Is any body performed rebuild master database?
I heard that we can perform online index rebuild activity on SQL 2005.
Did any one performed this?
Where exactly it differs from sql2000.
Is it possible to set up replication between an SQLServer Enterprise edition ( publisher )
and SQLServer Standard edition ( subscriber ), or do both...
For installation of Analysis services whether domain account/ local system account can be used for start the services.
Can you suggest for building new server hardware configurations.
Number of processors
Type of processor
I want small clarification when we implement Active/Active cluster,
i belive there are 2 virtual servers virt1 and virt2,instance inst1...
I want to uninstall Named instance. can you suggest best way.
I did not find named instance name in add remove programs.
To install MS-cluster services on my LAN what are the requirements.
I want to move MASTER database sp and xsp's to another server Master database.
Is there any way to transfer them.
My database size is around 8 GB. I have sufficient space on my shared backup drive.
even though my backup's getting failed.
In the SQL...
Below are i am getting from Application side, can i know the reason. Is it application error or database issue. Please let me know....
Can i install reporting services on SQL2k client machine?
Can we schedule custom script in SQLDM, if any one doing any operations to that database can we get alert?
Can you explain me active/passive and active/active clusters.
Recovery mode is Full
Suddenly my Log file has grown 100 time than my DB size.
Application side some issues due to this my log has grown to 100 GB where as my DB size is 1...
I have installed SQL Server 2005 on two machines i want to implement MIRROR.
When I am trying to register MIRROR server on PRINCIPAL. I...
We have a 4-node 3-instance cluster running SQL Server 2000 SP 3a.
We want to install Service Pack 4 and also configure AWE.
Could you tell me how...
I am planning to install on SQLServer 2000 Service pack4 active/passive mode on windows 2000 advanced server.Please let me know how to...
Separate names with a comma.