TSQL TestBits function for rapidly testing multiple switch settings

Are multiple binary switches becoming hard to manage? The TestBits function can help with that.

AND & OR

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.

RE: scripting views

1. I have around 150 views and ALL can be scripted out. So I don't know what are you talking about. 2. Are you using anything special like schemabinding or are the views dependencies Too Deep ? It may be worth researching a little bit more!

RE: DBA in PHX

Kingram: for Jr. level people the rate would likely be in the range of $45 - 60k / yr, and for Sr. level between $65 - 80k / yr Zach, sorry, but you don't meet our qualifications. While I can appreciate a certain amount of "sack" in an interview, I don't need any more loose […]

RE: PINTABLE

sp_tableoption 'tablename',@OptionName ='pintable' John Zacharkan

RE: With AWE, max server memory settings takes all mem

Hameed, Keep in mind that the /3GB and PAE switches apply to other Microsoft applications in addition to SQL Server EE. For example, Microsoft Exchange 2000. That is probably why you are seeing contradictory statements. Bottom line is this: In your configuration, SQL Server will grab all but 128 MB of RAM (reserved for the […]

RE: How-To Create Stored Proceedures

Hi, One way to get started is to use the Stored Procedure Wizard. Go into Enterprise Manager, Tool, Wizards, Storped Procedure. it will guide you thruhg some simple stored procs. Then go to Query Analyzers take a lool and see waht was generated. Good luck