question about best way to store an up or down value

I'm creating a table for maintenance records.

In each record many of the values are simply checkboxes.

In the database for these attributes, is a good way to store the state of these checkboxes as simple as 0 for false, 1 for true?

-DavidWithout getting into design issues, the best way would be to use a BIT datatype, with 0 used to indicate FALSE or OFF, and 1 to indicate TRUE or ON.

Question about AWE.

SQL2K SP3
From reading BOL, to enable AWE, I should simply need to:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', MyMax
RECONFIGURE
GO
And then start the SQL services. But a coworker of mine seems to think that
there's more to it then that. That SQL won't really be using AWE until we do
this something else. The best part is he's not sure what that something else
is. I think there's nothing else, but wanted to verify if I could.
TIA, ChrisRHi,Chris
http://www.sql-server-performance.com/awe_memory.asp
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
> SQL2K SP3
> From reading BOL, to enable AWE, I should simply need to:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', MyMax
> RECONFIGURE
> GO
> And then start the SQL services. But a coworker of mine seems to think
> that
> there's more to it then that. That SQL won't really be using AWE until we
> do
> this something else. The best part is he's not sure what that something
> else
> is. I think there's nothing else, but wanted to verify if I could.
> TIA, ChrisR|||And also http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp
See Lock Pages in memory priv.
Don't forget that if you install Sql2000sp4 you must get a hotfix otherwise
SQL will use half the memory (bug in the base SP4)
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eW7yW6TPGHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi,Chris
> http://www.sql-server-performance.com/awe_memory.asp
>
>
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
>> SQL2K SP3
>> From reading BOL, to enable AWE, I should simply need to:
>> sp_configure 'show advanced options', 1
>> RECONFIGURE
>> GO
>> sp_configure 'awe enabled', 1
>> RECONFIGURE
>> GO
>> sp_configure 'max server memory', MyMax
>> RECONFIGURE
>> GO
>> And then start the SQL services. But a coworker of mine seems to think
>> that
>> there's more to it then that. That SQL won't really be using AWE until we
>> do
>> this something else. The best part is he's not sure what that something
>> else
>> is. I think there's nothing else, but wanted to verify if I could.
>> TIA, ChrisR
>

Question about AWE.

SQL2K SP3
From reading BOL, to enable AWE, I should simply need to:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', MyMax
RECONFIGURE
GO
And then start the SQL services. But a coworker of mine seems to think that
there's more to it then that. That SQL won't really be using AWE until we do
this something else. The best part is he's not sure what that something else
is. I think there's nothing else, but wanted to verify if I could.
TIA, ChrisRHi,Chris
http://www.sql-server-performance.com/awe_memory.asp
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
> SQL2K SP3
> From reading BOL, to enable AWE, I should simply need to:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', MyMax
> RECONFIGURE
> GO
> And then start the SQL services. But a coworker of mine seems to think
> that
> there's more to it then that. That SQL won't really be using AWE until we
> do
> this something else. The best part is he's not sure what that something
> else
> is. I think there's nothing else, but wanted to verify if I could.
> TIA, ChrisR|||And also http://www.sqlservercentral.com/col...eadventures.asp
See Lock Pages in memory priv.
Don't forget that if you install Sql2000sp4 you must get a hotfix otherwise
SQL will use half the memory (bug in the base SP4)
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eW7yW6TPGHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi,Chris
> http://www.sql-server-performance.com/awe_memory.asp
>
>
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
>

Question about AWE.

SQL2K SP3
From reading BOL, to enable AWE, I should simply need to:
sp_configure 'show advanced options', 1
RECONFIGURE
GO
sp_configure 'awe enabled', 1
RECONFIGURE
GO
sp_configure 'max server memory', MyMax
RECONFIGURE
GO
And then start the SQL services. But a coworker of mine seems to think that
there's more to it then that. That SQL won't really be using AWE until we do
this something else. The best part is he's not sure what that something else
is. I think there's nothing else, but wanted to verify if I could.
TIA, ChrisR
Hi,Chris
http://www.sql-server-performance.com/awe_memory.asp
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
> SQL2K SP3
> From reading BOL, to enable AWE, I should simply need to:
> sp_configure 'show advanced options', 1
> RECONFIGURE
> GO
> sp_configure 'awe enabled', 1
> RECONFIGURE
> GO
> sp_configure 'max server memory', MyMax
> RECONFIGURE
> GO
> And then start the SQL services. But a coworker of mine seems to think
> that
> there's more to it then that. That SQL won't really be using AWE until we
> do
> this something else. The best part is he's not sure what that something
> else
> is. I think there's nothing else, but wanted to verify if I could.
> TIA, ChrisR
|||And also http://www.sqlservercentral.com/colu...adventures.asp
See Lock Pages in memory priv.
Don't forget that if you install Sql2000sp4 you must get a hotfix otherwise
SQL will use half the memory (bug in the base SP4)
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eW7yW6TPGHA.3924@.TK2MSFTNGP14.phx.gbl...
> Hi,Chris
> http://www.sql-server-performance.com/awe_memory.asp
>
>
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:312ACADD-F513-4D8F-B5D8-F69C2D2E9138@.microsoft.com...
>