Hi Elliott,

Thank you very much for your reply. But I am still struggling for a solution.

...

Hi Rambilla,

Your SQL Server is experiencing memory pressure.

...

Hi Venu,

Check these links. I'm sure that you will become security expert by following these great articles.

http://www.sql-server-performance.com/articles/dba/sql_security_p1.aspx

http://www.sql-server-performance.com/articles/dba/authorization_2005_p1.aspx

http://www.sql-server-performance.com/articles/dba/Analyzing_SQL_Server_Permissions_p1.aspx

http://www.developer.com/tech/article.php/10923_721441_2

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sqlserver2005logins/2474/

http://www.sqlservercentral.com/articles/Security/sqlserversecurityprosandconsofapplicationroles/1116/

Hi Lempster,

Thank you very much for your reply.

You are right....

Hi,

For your information only

Microsoft discourages the use of DBCC SHOWCONTIG . This is the official statement from the Microsoft in BOL 2008

"This feature will be removed in the next version...

Hi Balbir,

You're more than welcome.

...

Hi Balbir,

Check this link:

http://blogs.techrepublic.com.com/datacenter/?p=251

...

Hi Jaimin,

AFAIK, the index has to be reorganized if the the amount of fragmentation is...

Hi Tim,

...

Hi Wayne,

Here is an article which says that it's not recommended to have more than one instance installed on a single cluster node.

Hi Wayne,

In our cluster environment we are currently having around 5 instances running on a...

Hi Chaotic Coder,

Thank you very much for your reply.

...

Hi Derek,

The best way to monitor SQL server instances on a cluster is to use Cluster...

Hi Elliott,

Thank you very much for your reply.

...

Hi Elliott,

Finally, I was able to connect to the Oracle datasource using BIDS on a 64-bit machine. In the...