Please try following piece of code. Hope it will justify my previous post.

CREATE TABLE T1

(C1 INT);

CREATE TABLE T2

(C2 INT);

INSERT INTO T1 VALUES (3651);

INSERT INTO T2 VALUES (NULL);

SELECT * FROM T1,T2;

SELECT...

The primary purpose of a SQL Server database is to store and retrieve data, so intensive disk I/O is a core characteristic of the Database Engine. And because disk I/O...

If your main concern is 'Result of query A is NOT matching with query B' and you are confident that the results should match, please execute the queries without NOLOCK...

There is no straight way to achive this. You might need to write complex code using BIT operators.

Why do you want to do BIT operations? What is your application requirement....

It would be difficult to comment on the results as we don't know the database workload & database design.

You should not compare NULL with equality operators. you must use 'IS NULL' or 'IS NOT NULL' operators.

Thus (1=NULL) and (NULL=NULL) are bad operations.

Else, you may override default behavior of...

Please go through following MSDN articles before you take any action.

Transaction Log Truncation:

http://msdn.microsoft.com/en-us/library/ms189085.aspx

Factors That Can Delay Log Truncation:

http://msdn.microsoft.com/en-us/library/ms345414.aspx

Shrinking the Transaction Log:...

I don't think we are talking about geo-clusters here.

Mirror it first.

per MSDN:

Typically, when combining log shipping and database mirroring, the mirroring session is established before log shipping, although this is not required. Then the current principal database is...

I didn't get your question clearly. Is this Mirroring issue or Replication issue?

Clustering requires shared data storage between Active & Passive Nodes. Few softwares allow to share the local disk (am not talking about SAN) with multiple nodes but you would be...

I am just curious to know the reason for opting 'Active/Active' cluster in place of 'Active/Passive' Cluster. It would be easy to manage and if I understand the reason for...