Multi value "Select All"

Hi all
I have a multi-value drop down list as my report's parameter.
Once the report is executed with the selected parameter, I am
displaying the selected parameter also as a part of the report's
results.
Is there a way I can display the word "All" in the report results when
the user selects "Select All" of the report parameter?
At present it shows a long list of concatenated values of the drop down
list.
Thanks heapsI might be misunderstanding you, but you can display the parameter
label that is selected: Parameter.label instead of parameter.value|||I am sorry if my question was not clear.
I tried Parameter.Label, but gives an error if the parameter is a Multi
Value type.
So, one has to use Join(Parameter.Label,",").
This displays a list of all the paramters that were selected.
What I want is, if the user selects "Select All" instead of showing the
list of parameters, i should be able to display the word "All".
Does this make sense?
Thanks

MSSQL Server 2000 Memory Grows Incrementally

Hi All
My SQL Server keeps on taking memory(RAM) on the server without
releasing it.
There seems to be a memory leak.
On every query that gets executed the memory occupied by MSSQL grows.
Does this make the subsequent queries execute slowly?
Also even though i execute the same query multiple time the memory size
still increases.
What could be the possible reason for this?
Thanks & Regards
Vishal.
Vishal wrote:
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
This is normal behavior. SQL Server will cache data pages in memory as
they are loaded from disk. It won't release memory unless it is
configured for dynamic memory allocation, AND the OS requests it.
Having SQL data cached in memory is a good thing, let it use as much as
it needs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||The behaviour you are seeing is by design. Here is a KB article on the
subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/default...;en-us;q321363
Keith Kratochvil
"Vishal" <vishal.bhute@.gmail.com> wrote in message
news:1160134477.258235.198120@.h48g2000cwc.googlegr oups.com...
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
|||Dear Tracy,
How to set up the "dynamic memory allocation" ?
Thanks
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:4526486E.4090509@.realsqlguy.com...
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it. Having
> SQL data cached in memory is a good thing, let it use as much as it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Thanks Tracy
How to configure dynamic Memory Allocation?
Rgds
Vishal.
Tracy McKibben wrote:
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it.
> Having SQL data cached in memory is a good thing, let it use as much as
> it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
|||Vishal wrote:
> Thanks Tracy
> How to configure dynamic Memory Allocation?
See "Server Memory Options" under "Setting Configuration Options" in
Books Online...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Dear Tracy,
Thank you for your advice.
Peter
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452B94DC.8000706@.realsqlguy.com...
> Vishal wrote:
> See "Server Memory Options" under "Setting Configuration Options" in Books
> Online...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com

MSSQL Server 2000 Memory Grows Incrementally

Hi All
My SQL Server keeps on taking memory(RAM) on the server without
releasing it.
There seems to be a memory leak.
On every query that gets executed the memory occupied by MSSQL grows.
Does this make the subsequent queries execute slowly?
Also even though i execute the same query multiple time the memory size
still increases.
What could be the possible reason for this?
Thanks & Regards
Vishal.Vishal wrote:
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>
This is normal behavior. SQL Server will cache data pages in memory as
they are loaded from disk. It won't release memory unless it is
configured for dynamic memory allocation, AND the OS requests it.
Having SQL data cached in memory is a good thing, let it use as much as
it needs.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||The behaviour you are seeing is by design. Here is a KB article on the
subject:
INF: SQL Server Memory Usage
http://support.microsoft.com/defaul...b;en-us;q321363
Keith Kratochvil
"Vishal" <vishal.bhute@.gmail.com> wrote in message
news:1160134477.258235.198120@.h48g2000cwc.googlegroups.com...
> Hi All
> My SQL Server keeps on taking memory(RAM) on the server without
> releasing it.
> There seems to be a memory leak.
> On every query that gets executed the memory occupied by MSSQL grows.
> Does this make the subsequent queries execute slowly?
> Also even though i execute the same query multiple time the memory size
> still increases.
> What could be the possible reason for this?
> Thanks & Regards
> Vishal.
>|||Dear Tracy,
How to set up the "dynamic memory allocation" ?
Thanks
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:4526486E.4090509@.realsqlguy.com...
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it. Having
> SQL data cached in memory is a good thing, let it use as much as it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Thanks Tracy
How to configure dynamic Memory Allocation'
Rgds
Vishal.
Tracy McKibben wrote:
> Vishal wrote:
> This is normal behavior. SQL Server will cache data pages in memory as
> they are loaded from disk. It won't release memory unless it is
> configured for dynamic memory allocation, AND the OS requests it.
> Having SQL data cached in memory is a good thing, let it use as much as
> it needs.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com|||Vishal wrote:
> Thanks Tracy
> How to configure dynamic Memory Allocation'
See "Server Memory Options" under "Setting Configuration Options" in
Books Online...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Dear Tracy,
Thank you for your advice.
Peter
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:452B94DC.8000706@.realsqlguy.com...
> Vishal wrote:
> See "Server Memory Options" under "Setting Configuration Options" in Books
> Online...
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com