Thanks for clarifications.

Daniel

Hi Paul,

Great article about CHECKSUM and DBCC CHECKDB. Regarding DBCC CHECKDB you said that it checks in-memory page before CHECKPOINT is done, so it could detect some in-memory page fault....

Thanks for your advices. I found some articles that explained how to do a Multi-Site Cluster, for sure we need external help.

Regarding the connections pooling the applications don't use ADO.NET...

Thanks for your answer. It is possible to have a MSSQL Cluster on Windows 2008 R2 with two physical server for SQL Server 2008 R2 (Standard Edition) and SAN mirroring?...

Hi,

In SQL 2008 putting the database in Recovery Simple will truncate the log. It is the only way that truncates the log

After you put your DB in recovery simple doing

DBCC...

Hi,

I run today same statements in both databases and surprise, the Optimizer shows almost identical Execution Plan (for one statement is asking to create a new index, but it's not...

Hi,

Yes, I created the index, but after that is asking to create another one. For sure the statement run a litle faster but it still doing some scans in place...

Thaks for your explanation. You're right. In Configuration Manager I have the same value for this property.

Thanks. I run Update Statistics on both databases and I have to say that I was surprised by the fact that after running again the statements, the statement that was...

Hi,

If you are running SQL Server 2008 64 bits on Windows 2008 64 bits the advanced properties shows as in attachment file.

How did you get the advanced properties for your...

Thank you again.

Thanks for your answer. Seems to be logic. What happens if I install SP1 on the passive node (once the active that was passive has SP1 installed, so master, msdb,...

Thanks for your answers.

If SCSI clustering is not supporting with Windows 2003, what kind of clustering is supported with?

Do you know when SQL Server 2005 will be released?

What we need...

Hi,

First check your log file with the command in Query Analizer in your database:

DBCC LOGFILE

If the last record in column "STATUS" have the value 0 than pass the command:

DBCC...