WHICH VERSION OF MDAC SHOULD I INSTLL ON WINDOWS NT 4.0
SERVER WTIH SQL 6.5 SERVER SP 5
to connect or transact or run procdure with SQL server
2000 from SQL 6.5
server
ThanksIf you need to connect to a named instance on the SQL Server 2000 machine
with creating an alias, the lowest level of MDAC should be MDAC 2.6.
However, if you want to use all the functionality of the SQL Server itself
you should install the level of MDAC that is installed on the SQL Server
2000 machine.
Rand
This posting is provided "as is" with no warranties and confers no rights.sql
Showing posts with label server2000. Show all posts
Showing posts with label server2000. Show all posts
Sunday, March 25, 2012
Monday, March 19, 2012
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linea
r
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. S
ee
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linea
r
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. S
ee
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >
> > What are my options to best use the RAM?
> > 1. /3GB in Boot.ini and AWE not enabled
> > 2. /3GB in Boot.ini and AWE enabled.
> >
> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> > need
> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> > MEMORY datatype is INT and can only take 2GB
> >
> > Can anyone advise
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>> It depends on how much memory you need for the operating system plus
>> other
>> stuff you may have on the server. 1GB is great but with a simple server
>> with just SQL Server and SQL Agent running 512 will be fine. Using only
>> /3GB is simple and works you could combine them and allow for 3GB of
>> linear
>> memory and 500MB for AWE.
>> The configure value for memory is in MB so an int is plenty big enough.
>> See
>> BOL for details.
>> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
>> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
>> >
>> > What are my options to best use the RAM?
>> > 1. /3GB in Boot.ini and AWE not enabled
>> > 2. /3GB in Boot.ini and AWE enabled.
>> >
>> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
>> > need
>> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
>> > SERVER
>> > MEMORY datatype is INT and can only take 2GB
>> >
>> > Can anyone advise
>>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> > Thks Danny.
> >
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> >
> > Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> > tell it to) use 3GB of RAM?
> >
> > "Danny" wrote:
> >
> >> It depends on how much memory you need for the operating system plus
> >> other
> >> stuff you may have on the server. 1GB is great but with a simple server
> >> with just SQL Server and SQL Agent running 512 will be fine. Using only
> >> /3GB is simple and works you could combine them and allow for 3GB of
> >> linear
> >> memory and 500MB for AWE.
> >>
> >> The configure value for memory is in MB so an int is plenty big enough.
> >> See
> >> BOL for details.
> >>
> >> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> >> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >> >
> >> > What are my options to best use the RAM?
> >> > 1. /3GB in Boot.ini and AWE not enabled
> >> > 2. /3GB in Boot.ini and AWE enabled.
> >> >
> >> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> >> > need
> >> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
> >> > SERVER
> >> > MEMORY datatype is INT and can only take 2GB
> >> >
> >> > Can anyone advise
> >>
> >>
> >>
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone adviseIt depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >
> > What are my options to best use the RAM?
> > 1. /3GB in Boot.ini and AWE not enabled
> > 2. /3GB in Boot.ini and AWE enabled.
> >
> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> > need
> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> > MEMORY datatype is INT and can only take 2GB
> >
> > Can anyone advise
>
>|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
>> It depends on how much memory you need for the operating system plus
>> other
>> stuff you may have on the server. 1GB is great but with a simple server
>> with just SQL Server and SQL Agent running 512 will be fine. Using only
>> /3GB is simple and works you could combine them and allow for 3GB of
>> linear
>> memory and 500MB for AWE.
>> The configure value for memory is in MB so an int is plenty big enough.
>> See
>> BOL for details.
>> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
>> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
>> >
>> > What are my options to best use the RAM?
>> > 1. /3GB in Boot.ini and AWE not enabled
>> > 2. /3GB in Boot.ini and AWE enabled.
>> >
>> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
>> > need
>> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
>> > SERVER
>> > MEMORY datatype is INT and can only take 2GB
>> >
>> > Can anyone advise
>>|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
> > Thks Danny.
> >
> > Actually all I wanted to know was, if I set /3GB and do not want to turn
> > on
> > AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> > INT?
> >
> > Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> > tell it to) use 3GB of RAM?
> >
> > "Danny" wrote:
> >
> >> It depends on how much memory you need for the operating system plus
> >> other
> >> stuff you may have on the server. 1GB is great but with a simple server
> >> with just SQL Server and SQL Agent running 512 will be fine. Using only
> >> /3GB is simple and works you could combine them and allow for 3GB of
> >> linear
> >> memory and 500MB for AWE.
> >>
> >> The configure value for memory is in MB so an int is plenty big enough.
> >> See
> >> BOL for details.
> >>
> >> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> >> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
> >> >I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> >> >
> >> > What are my options to best use the RAM?
> >> > 1. /3GB in Boot.ini and AWE not enabled
> >> > 2. /3GB in Boot.ini and AWE enabled.
> >> >
> >> > If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> >> > need
> >> > to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX
> >> > SERVER
> >> > MEMORY datatype is INT and can only take 2GB
> >> >
> >> > Can anyone advise
> >>
> >>
> >>
>
>
/3gb
I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone advise
It depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise
|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>
|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
What are my options to best use the RAM?
1. /3GB in Boot.ini and AWE not enabled
2. /3GB in Boot.ini and AWE enabled.
If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL need
to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
MEMORY datatype is INT and can only take 2GB
Can anyone advise
It depends on how much memory you need for the operating system plus other
stuff you may have on the server. 1GB is great but with a simple server
with just SQL Server and SQL Agent running 512 will be fine. Using only
/3GB is simple and works you could combine them and allow for 3GB of linear
memory and 500MB for AWE.
The configure value for memory is in MB so an int is plenty big enough. See
BOL for details.
"Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>I have SQL Server2000 Ent. sitting on Win2003 Ent. with 4GB RAM.
> What are my options to best use the RAM?
> 1. /3GB in Boot.ini and AWE not enabled
> 2. /3GB in Boot.ini and AWE enabled.
> If AWE is not enabled and I have 4GB with /3GB in boot.ini, do I STILL
> need
> to set the MAX SERVER MEMORY to 3GB? If so, I cannot, since the MAX SERVER
> MEMORY datatype is INT and can only take 2GB
> Can anyone advise
|||Thks Danny.
Actually all I wanted to know was, if I set /3GB and do not want to turn on
AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
INT?
Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
tell it to) use 3GB of RAM?
"Danny" wrote:
> It depends on how much memory you need for the operating system plus other
> stuff you may have on the server. 1GB is great but with a simple server
> with just SQL Server and SQL Agent running 512 will be fine. Using only
> /3GB is simple and works you could combine them and allow for 3GB of linear
> memory and 500MB for AWE.
> The configure value for memory is in MB so an int is plenty big enough. See
> BOL for details.
> "Miles Obrien" <Miles Obrien@.discussions.microsoft.com> wrote in message
> news:E1F0F023-61D5-4DC2-BD9F-C511570E371A@.microsoft.com...
>
>
|||> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
The 'max server memory' specification is in MB. 3 GB = 3072 MB.
Hope this helps.
Dan Guzman
SQL Server MVP
"Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...[vbcol=seagreen]
> Thks Danny.
> Actually all I wanted to know was, if I set /3GB and do not want to turn
> on
> AWE, how do I set the MAX SERVER MEMORY to 3GB when it has a datatype of
> INT?
> Or - with AWE disabled and /3GB in Boot.ini how do I know SQL SERVER (or
> tell it to) use 3GB of RAM?
> "Danny" wrote:
|||Darn!
Was thinking the MAX SERVER MEMORY was in bytes!!!
In that case will leave it as it's default!
Thks Guys!
"Dan Guzman" wrote:
> The 'max server memory' specification is in MB. 3 GB = 3072 MB.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Miles Obrien" <MilesObrien@.discussions.microsoft.com> wrote in message
> news:47EAA1B3-82F1-4091-AC58-A08EF90BAD90@.microsoft.com...
>
>
Thursday, February 16, 2012
**sum**
Hi
I've follwoing data in table1 in SQL server2000,and I want to get the
result as below:
table1 result
Id Qty
-- --
1 500 1 500
2 502 2 1002
3 400 3 1402
4 140 4 1542
how is it possible in select statement?
Any help would be thankful.Here you go
CREATE TABLE #Table1(id int PRIMARY KEY, Quantity int NOT NULL)
INSERT INTO #Table1 VALUES(1,500)
INSERT INTO #Table1 VALUES(2,502)
INSERT INTO #Table1 VALUES(3,400)
INSERT INTO #Table1 VALUES(4,140)
SELECT id,
(SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
FROM #Table1 O
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
<R> wrote in message news:opsyn8fezjmw7tkz@.system109.parskhazar.net...
> Hi
> I've follwoing data in table1 in SQL server2000,and I want to get the
> result as below:
> table1 result
> Id Qty
> -- --
> 1 500 1 500
> 2 502 2 1002
> 3 400 3 1402
> 4 140 4 1542
>
> how is it possible in select statement?
> Any help would be thankful.|||I missed the ORDER BY
SELECT id,
(SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
FROM #Table1 O
ORDER By ID
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Roji. P. Thomas" <thomasroji@.gmail.com> wrote in message
news:ecqyxfV0FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Here you go
>
> CREATE TABLE #Table1(id int PRIMARY KEY, Quantity int NOT NULL)
> INSERT INTO #Table1 VALUES(1,500)
> INSERT INTO #Table1 VALUES(2,502)
> INSERT INTO #Table1 VALUES(3,400)
> INSERT INTO #Table1 VALUES(4,140)
> SELECT id,
> (SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
> FROM #Table1 O
>
> --
> Roji. P. Thomas
> Net Asset Management
> http://toponewithties.blogspot.com
>
> <R> wrote in message news:opsyn8fezjmw7tkz@.system109.parskhazar.net...
>
I've follwoing data in table1 in SQL server2000,and I want to get the
result as below:
table1 result
Id Qty
-- --
1 500 1 500
2 502 2 1002
3 400 3 1402
4 140 4 1542
how is it possible in select statement?
Any help would be thankful.Here you go
CREATE TABLE #Table1(id int PRIMARY KEY, Quantity int NOT NULL)
INSERT INTO #Table1 VALUES(1,500)
INSERT INTO #Table1 VALUES(2,502)
INSERT INTO #Table1 VALUES(3,400)
INSERT INTO #Table1 VALUES(4,140)
SELECT id,
(SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
FROM #Table1 O
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
<R> wrote in message news:opsyn8fezjmw7tkz@.system109.parskhazar.net...
> Hi
> I've follwoing data in table1 in SQL server2000,and I want to get the
> result as below:
> table1 result
> Id Qty
> -- --
> 1 500 1 500
> 2 502 2 1002
> 3 400 3 1402
> 4 140 4 1542
>
> how is it possible in select statement?
> Any help would be thankful.|||I missed the ORDER BY
SELECT id,
(SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
FROM #Table1 O
ORDER By ID
Roji. P. Thomas
Net Asset Management
http://toponewithties.blogspot.com
"Roji. P. Thomas" <thomasroji@.gmail.com> wrote in message
news:ecqyxfV0FHA.3892@.TK2MSFTNGP12.phx.gbl...
> Here you go
>
> CREATE TABLE #Table1(id int PRIMARY KEY, Quantity int NOT NULL)
> INSERT INTO #Table1 VALUES(1,500)
> INSERT INTO #Table1 VALUES(2,502)
> INSERT INTO #Table1 VALUES(3,400)
> INSERT INTO #Table1 VALUES(4,140)
> SELECT id,
> (SELECT SUM(Quantity) FROM #Table1 WHERE id <= O.id) As RunningTotal
> FROM #Table1 O
>
> --
> Roji. P. Thomas
> Net Asset Management
> http://toponewithties.blogspot.com
>
> <R> wrote in message news:opsyn8fezjmw7tkz@.system109.parskhazar.net...
>
Subscribe to:
Posts (Atom)