Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Bitwise Operators Rss

   Items 1 to 3 of 3   

TSQL TestBits function for rapidly testing multiple switch settings

Are multiple binary switches becoming hard to manage? The TestBits function can help with that.  Read more...
By Chuck Hoffman 2012/04/09 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,043 reads


By VM-723206 2009/10/14 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,668 reads

Who was that Affinity Masked Man?

Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.  Read more...
By Craig Outcalt 2008/10/17 | Source: | Category: bitwise operators
Rating: |  Discuss |   Briefcase | 3,858 reads
   Items 1 to 3 of 3   
t-sql (2)    
affinity mask (1)    
binary (1)    
cpu threads (1)    
tempdb threads (1)