Viewing 12 posts - 1,996 through 2,007 (of 2,007 total)
Please try following piece of code. Hope it will justify my previous post.
CREATE TABLE T1
CREATE TABLE T2
INSERT INTO T1 VALUES (3651);
INSERT INTO T2 VALUES (NULL);
SELECT * FROM T1,T2;
September 30, 2011 at 4:34 am
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...
September 30, 2011 at 4:13 am
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...
September 30, 2011 at 4:01 am
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....
September 30, 2011 at 3:56 am
It would be difficult to comment on the results as we don't know the database workload & database design.
September 30, 2011 at 3:42 am
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...
September 30, 2011 at 3:37 am
Please go through following MSDN articles before you take any action.
Transaction Log Truncation:
Factors That Can Delay Log Truncation:
Shrinking the Transaction Log:...
September 30, 2011 at 2:40 am
I don't think we are talking about geo-clusters here.
September 30, 2011 at 2:14 am
Mirror it first.
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...
September 30, 2011 at 2:08 am
I didn't get your question clearly. Is this Mirroring issue or Replication issue?
September 30, 2011 at 1:48 am
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...
September 30, 2011 at 1:43 am
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...
September 30, 2011 at 1:24 am