max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AW
E
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM
.
http://www.microsoft.com/windowsser...es.msp
x
--
MG
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsser...es.msp
x
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/d...br />
8dbn.asp
"Tristan" wrote:

> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE,
AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

max memory for 2003 & 2k

Hi all,
I have a Sql Server Enterprise edition running under Windows Server 2003,
Standard Edition, and my hardware supports up to 16 gigs of RAM.
Currently I am running fine with 4 gigs and switch /3GB. I was wondering
however if it would be possible to upgrade up to 16 gigs RAM with same
configuration, I mean, same sql & windows version, and only setting /PAE, AWE
and max memory for the server to 15.
Thanks in advance,
TristanI think Windows 2003 Server Standard edition only supports up to 4 GB of RAM.
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
--
MG
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>|||I think you will need to upgrade Windows 2003 to Enterprise
http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx
Maximum Capacity Specifications (SQL Server 2000)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
"Tristan" wrote:
> Hi all,
> I have a Sql Server Enterprise edition running under Windows Server 2003,
> Standard Edition, and my hardware supports up to 16 gigs of RAM.
> Currently I am running fine with 4 gigs and switch /3GB. I was wondering
> however if it would be possible to upgrade up to 16 gigs RAM with same
> configuration, I mean, same sql & windows version, and only setting /PAE, AWE
> and max memory for the server to 15.
> Thanks in advance,
> Tristan
>

Matrix sorting

Hi. I need to implement a matrix that supports column sorting just like a table.
For example, given a matrix that contains...

Col1 Col2
Row1 1 8
Row2 2 6
Row3 3 7

...if the user clicks on "Col2", I need the matrix to look like this:

Col1 Col2
Row2 2 6
Row3 3 7
Row1 1 8

I cannot use the interactive sort feature since the matrix must be WYSIWYG with the printed copy and the built-in interactive sort arrows do appear in printed output.

Here's my partial solution; my hope is that someone can point me in the right direction from here:

When the user clicks on a column heading I will jump to a URL such as:
http://myserver/myreport.aspx?SortField=Col2&SortDirection=Ascending

SortField and SortDirection are parsed by the web app and passed as parameters to my report.

So, after the user clicks on Col2 the report knows the following:
Parameters!SortField.Value = "Col2"
and
Parameters!SortDirection.Value = "Ascending"

Given this information, is there a way to tell the report's matrix to actually display the data in the order shown in the example above.

Thanks for any help you can provide.
Try right click on matrix and select matrix properties, select groups, select edit matrix group, select the sorting tab, change the expression value should be col 12 and direction descending. It worked for me.