Index on computed columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by VM » Index on computed columns

Index on computed columns

Rate Topic

Display Mode

Topic Options

Author

Message

VM-723206

Posted Monday, September 27, 2010 9:55 PM

SSChasing Mays

Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649, Visits: 263

Comments posted to this topic are about the item Index on computed columns

Post #994168

ziangij

Posted Monday, September 27, 2010 9:56 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,529, Visits: 359

nice & simple... thanks :)

Post #994169

madhankumar.g

Posted Tuesday, September 28, 2010 4:02 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, June 23, 2011 12:45 AM
Points: 21, Visits: 11

Hi,

^ operator will do the Bitwise XOR operation.

Example:

A=170
B=75

A^B = 225

Explanation:

(A ^ B)
170 0000 0000 1010 1010
75 0000 0000 0100 1011
-------------------
225 0000 0000 1110 0001

This information may be usefull to someone. Smile

Post #994291

NickBalaam

Posted Tuesday, September 28, 2010 5:04 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:27 AM
Points: 342, Visits: 788

Good question, nice and easy. I like them ones Smile

Post #994318

Daniel Bowlin

Posted Tuesday, September 28, 2010 7:13 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:10 PM
Points: 2,673, Visits: 2,418

Nice question, thanks.

Post #994399

sjimmo

Posted Tuesday, September 28, 2010 7:38 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:15 AM
Points: 2,865, Visits: 2,467

Good question - good chance to review

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

Post #994433