max mem field not working

Hi,
i explained to SQL 2005 express that the max mem it could use was 500mb (via
the Max server memory field in Mem option on properties).
yet when i examine task manager its using 800mb.
Any idea why ?
Need to stop restart for changes to take effect maybe ?
Thanks
Scott
> i explained to SQL 2005 express that the max mem it could use was 500mb
> (via the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
Yes, it is not going to choke a SQL Server process that is already running
in more memory space.
You can see details in:
select * from sys.configurations where [name] = 'max server memory (MB)';
I'll bet "value_in_use" is > "maximum"... that will correct itself once you
stop and start SQL Server.
|||Additionally to what Aaron said, take in consideration that SQL Server
2005 Express will take a bit more memory than that anyway, because the
memory specified is exclusively for the memory pool. Except something
between 30mb to 100mb extra to that 800mb.
Cesar Vega
http://www.databasecorner.com
On Mar 21, 9:58 am, "Scott" <s...@.yahoo.com> wrote:
> Hi,
> i explained to SQL 2005 express that the max mem it could use was 500mb (via
> the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
> Thanks
> Scott
sql

max mem field not working

Hi,
i explained to SQL 2005 express that the max mem it could use was 500mb (via
the Max server memory field in Mem option on properties).
yet when i examine task manager its using 800mb.
Any idea why ?
Need to stop restart for changes to take effect maybe ?
Thanks
Scott> i explained to SQL 2005 express that the max mem it could use was 500mb
> (via the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
Yes, it is not going to choke a SQL Server process that is already running
in more memory space.
You can see details in:
select * from sys.configurations where [name] = 'max server memory (MB)'
;
I'll bet "value_in_use" is > "maximum"... that will correct itself once you
stop and start SQL Server.|||Additionally to what Aaron said, take in consideration that SQL Server
2005 Express will take a bit more memory than that anyway, because the
memory specified is exclusively for the memory pool. Except something
between 30mb to 100mb extra to that 800mb.
Cesar Vega
http://www.databasecorner.com
On Mar 21, 9:58 am, "Scott" <s...@.yahoo.com> wrote:
> Hi,
> i explained to SQL 2005 express that the max mem it could use was 500mb (v
ia
> the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
> Thanks
> Scott

max mem field not working

Hi,
i explained to SQL 2005 express that the max mem it could use was 500mb (via
the Max server memory field in Mem option on properties).
yet when i examine task manager its using 800mb.
Any idea why ?
Need to stop restart for changes to take effect maybe ?
Thanks
Scott> i explained to SQL 2005 express that the max mem it could use was 500mb
> (via the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
Yes, it is not going to choke a SQL Server process that is already running
in more memory space.
You can see details in:
select * from sys.configurations where [name] = 'max server memory (MB)';
I'll bet "value_in_use" is > "maximum"... that will correct itself once you
stop and start SQL Server.|||Additionally to what Aaron said, take in consideration that SQL Server
2005 Express will take a bit more memory than that anyway, because the
memory specified is exclusively for the memory pool. Except something
between 30mb to 100mb extra to that 800mb.
Cesar Vega
http://www.databasecorner.com
On Mar 21, 9:58 am, "Scott" <s...@.yahoo.com> wrote:
> Hi,
> i explained to SQL 2005 express that the max mem it could use was 500mb (via
> the Max server memory field in Mem option on properties).
> yet when i examine task manager its using 800mb.
> Any idea why ?
> Need to stop restart for changes to take effect maybe ?
> Thanks
> Scott

Max character in field

In a SQL Server Db, what is the maximum amount of data a field can hold?

I am using right now nvarchar with a length of 4000.

Is there another setting to allow even more in a field?

Thanks all,

ZathA VARCHAR can hold up to 8000 characters in SQL 2000. If you need more, look at the TEXT type.

Matrix with totals at the top and a empty row

Hi,
I would like to have the following,
field 1 field 2 field 3
---
empty row
total 1000 1000 1000
empty row
field 4 2000 2000 2000
field 5 8000 8000 8000
Any advice on how to do that?Set Subtotal position to "Before" and use top and bottom padding to add
space around subtotal
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Reg" <reg@.dsl.za.org> wrote in message
news:eB47v2amEHA.2504@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I would like to have the following,
> field 1 field 2 field 3
> ---
> empty row
> total 1000 1000 1000
> empty row
> field 4 2000 2000 2000
> field 5 8000 8000 8000
> Any advice on how to do that?
>|||Thanks this works.
Now just one more problem. If we use the example below, on the column
grouping(Contains Months) have an iif to check if the date is before a
parameter passed to the report. I then use either one or the other field
from the database depending on whether it is true or false.
When I then add the total it would give me the wrong value, not really sure
which value it is giving me, but it always one value from the column and not
a calculated value.
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:ev416MhmEHA.2504@.TK2MSFTNGP14.phx.gbl...
> Set Subtotal position to "Before" and use top and bottom padding to add
> space around subtotal
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Reg" <reg@.dsl.za.org> wrote in message
> news:eB47v2amEHA.2504@.TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > I would like to have the following,
> >
> > field 1 field 2 field 3
> > ---
> > empty row
> > total 1000 1000 1000
> > empty row
> > field 4 2000 2000 2000
> > field 5 8000 8000 8000
> >
> > Any advice on how to do that?
> >
> >
>|||Would you like to create simple report that exhibits this problem and e-mail
it to me?
Thanks,
Lev
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Reg" <reg@.dsl.za.org> wrote in message
news:%23NDgWQimEHA.3876@.TK2MSFTNGP15.phx.gbl...
> Thanks this works.
> Now just one more problem. If we use the example below, on the column
> grouping(Contains Months) have an iif to check if the date is before a
> parameter passed to the report. I then use either one or the other field
> from the database depending on whether it is true or false.
> When I then add the total it would give me the wrong value, not really
> sure
> which value it is giving me, but it always one value from the column and
> not
> a calculated value.
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
> news:ev416MhmEHA.2504@.TK2MSFTNGP14.phx.gbl...
>> Set Subtotal position to "Before" and use top and bottom padding to add
>> space around subtotal
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Reg" <reg@.dsl.za.org> wrote in message
>> news:eB47v2amEHA.2504@.TK2MSFTNGP14.phx.gbl...
>> > Hi,
>> >
>> > I would like to have the following,
>> >
>> > field 1 field 2 field 3
>> > ---
>> > empty row
>> > total 1000 1000 1000
>> > empty row
>> > field 4 2000 2000 2000
>> > field 5 8000 8000 8000
>> >
>> > Any advice on how to do that?
>> >
>> >
>>
>

Matrix visibility and toggling with multi row fields

I have a matrix with two row fields. The second one doesnt show unless i press the toggle button on the first row field. How can make the first row field automatically expanded to show the second row field?

Thanks.

Is it 2 row groups? If so, go to your second row group, edit and check the visibility tab. Make sure it isn't controlled by another report item.|||Yes it is 2 row groups, it is not controlled by any other items and it is not set to hidden. This is in the properties of the textbox correct?|||I found the problem, i was looking at the text box properties, when you right click on the cell, you must select edit group, not properties.

Matrix SubTotals

I have subtotal at the bottom of the matrix. I am using Distinct Count in the expression field of matrix. But when I run the report, The Subtotal is giving the sum of all not the Distict counts. I can see the properties of Subtotal row. But I can not find the expression Property for that. Please help me anyone know it or had this issue.

I appreciate your help.

Thanks in advance

Rams

Hi ramsk

The subtotal expression in matrix report cannot be directley accesed.
You need to use custom code if you wish to manipulate the data in a different
way. This is because the expression used in the Matrix subtotal is the same as that
of the detail rows by default.

Custom code can be written using vb.NET or c# by going to report properties
and selecting the code tab. Write the function to accept integer values(or whichever data type you use)
and the call it from the detail cell within the matrix using the following expression:

=Code.<insert function name here without sharp bracets>(<field name here without sharp brackets>)

EX: =Code.GetFields(Fields!Net_Invoice.Value)

Now you can do a count on the values using vb/c#
Using this method even the most complex calculations can be done.

Gerhard Davids

|||

Thank you Gerhard Davids. I don't know vb.NET/C# coding. I will try to do that.

Thanks,

Ramsk

|||

Actually,

You can access the subtotal for Matrix report. Click on the green triangle of your matrix totals and you can write your expression there.

Hammer

|||

Hi Hammer,

I'm sorry to have to inform you that this is in fact
not possible. There has been much contravercy
about this and it has been causing many people
headaches including me.

Thus we have been using this very tedious and
redundant workaround.If you follow this link you
see in the newsgroup discussion that clearly
states: it's not possible at this time.

Also if you search around a bit you will get the
same result. Even with CTP2 this functionality
is not available.

Just thaught I'd let you know as not to get some
peoples hopes up.

Gerhard Davids

Matrix Subtotal is not summing

Hi,
I got a matrix, and a subtotal column (R-click on the column field, and
select "subtotal"), but at runtime the column is showing the value of the
first column, Matrix Subtotal is not summing.
Why is that.. ?
help please.
the same is when i make a subtotal for rows...I solved using SUM() in the data field of the matrix.
Tx.
"JuanCG_Col" wrote:
> Hi,
> I got a matrix, and a subtotal column (R-click on the column field, and
> select "subtotal"), but at runtime the column is showing the value of the
> first column, Matrix Subtotal is not summing.
> Why is that.. ?
> help please.
> the same is when i make a subtotal for rows...

Matrix Rows

Is it possible to move rows in a matrix up and down from its original
position? Preferably in a drag n drop structure.
Everytime I add a new field to a matrix I need to do manually change the
field names in the text box in the position I need the new field name.
Thanks.Do you have list of fields,you want to see on the matrix
I mean when you are saying i am adding new field ,i feel you cant get
additonal column unless you add in the table or stored procedure you
have to compile
So by assuming you have the list of filed names before you run the
report,
1)have a parametre,in that go to Non -Queried values,give the field
name desc in drop down
2)in place of column header ,give expression like
iif(parametre=1,"Desc",IIF(param=2,"Desc2","desc3)))
3)In detailcell
iif(parametre=1,"Fields!Desc.Value",IIF(param=2,"Fields!Desc2","Fields!desc3.value)))
Regards
Raj Deep.A
Brian Shannon wrote:
> Is it possible to move rows in a matrix up and down from its original
> position? Preferably in a drag n drop structure.
> Everytime I add a new field to a matrix I need to do manually change the
> field names in the text box in the position I need the new field name.
> Thanks.

Matrix row total

I have a count(field!orderstamp.Value) in a field and I would like to
show the percentage that number is of the whole row?
I can add a column next to it, but how do I show a percentage of a row
in a matrix?
Thanks.Assuming you have a matrix row grouping called "MatrixRowGroup", you can try
this:
=Count(Fields!orderstamp.Value) / Count(Fields!orderstamp.Value,
"MatrixRowGroup")
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"John Geddes" <john_g@.alamode.com> wrote in message
news:OVtGb$p8EHA.2804@.TK2MSFTNGP15.phx.gbl...
> I have a count(field!orderstamp.Value) in a field and I would like to
> show the percentage that number is of the whole row?
> I can add a column next to it, but how do I show a percentage of a row
> in a matrix?
> Thanks.
>

Matrix report, date: 1900-01-01 wrong!! Suppose to be empty, how?

Hi

I am making a report in Visual Studio. I’m making a matrix report. I have made a UNION of 2 tables. One of them has a field called Date and the other one does not. But to make a UNION of these 2 tables so that the results are printed in a Matrix I have to have the same fields’ aliases at least. So what I did is that in the second table is:

SELECT ‘ ‘ AS ‘Date’

Right?

Now, in the report the first table gives me the dates in a format:

=Format(Fields!Estimated_Close_Date.Value, "yyyy-MM-dd")

But, the second table is it doesn’t have a date in that field when I run the report it gives me:

1900-01-01

Something I don’t want.

So, how do I make it understand that the second tables date field is suppose to be empty?

Try something like this:

SELECT myDate AS DATE FROM MyTable

UNION ALL

SELECT CASE WHEN myBlankField = ' ' THEN ' ' ELSE ' ' END FROM OtherTable

And choose a field that is NOT a date for myBlankField. This will put blanks in the result set, but you can always just filter those out later.

|||

Thanks for your quick answer, sounds interesting, but I don't know quite where to put your example. Here's the code I have, maybe you know.

SELECT estimatedclosedate AS 'Date', blablabla...

INTO TempTable1

FROM blablabla join blabla and so on

WHERE blablabla AND blabla AND blabla and so on

SELECT ' ' AS 'Date', blablabla... -- This is the date that is troubling me

INTO TempTable2

FROM blablabla join blabla and so on

WHERE blablabla AND blabla AND blabla and so on

SELECT * FROM TempTable1

UNION

SELECT * FROM TempTable2

The TempTable1 gives me Opportunities from a CRM system, the TempTable2 gives me Ongoing Business in the CRM system. Of course, Opportunities have an estimated close date and Ongoing Business has not … so I just want it to show an empty cell in the matrix report.

So, where exactly could I put your suggestion?

|||

try -- select null as 'Date'., xyz........into temptable

Priyank

|||

Worked perfectly!!! Thanks mate!!!|||

can you please mark it as answer...|||

By the way ... do you know anything about my other thread I have here? About putting a tooltip window thing on one of my filters? One of my filters is done that the user can write what ever he wishes to filter on, either exactly or even with a % ... the thing is that I don't want to write on the Prompt: "Tradelane (STO-LAX, or STO%, or %STO) ... it's just to long ... do you happen to know how?

|||Mark it as answer? DONE!!

Matrix Report and Expression on field

I have a matrix report that has two columns, and one of the colums has the following expression for background color:

=IIF( Fields!Percentile.Value >= .10, "Yellow", "White")

Basically if the percent is greater than 10 highlight the field, for some reason i have some fields that dont show up yellow, see below:

http://duhaas.googlepages.com/percent.Jpg

your colour expression needs to wrap the field reference with the same aggregate function as the textbox value expression.

So, if you are using: =sum(Fields!Percentile.Value) as your value then change the colour expression to

=IIF( SUM(Fields!Percentile.Value) >= .10, "Yellow", "White")

this is because when no aggregate function is specified the the first value returned is used by default to evaluate the expression.

|||YOU DA MAN

Matrix PDF

Is there some sort of calculation to make a matrix export to pdf without page breaks?
I have
2 dynamic rows
1 dynamic column
1 value field
Please help
thanksPlease make sure that your report is setup as follows:
Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:CE79F248-E5B9-4500-84C6-5CB91195BA6C@.microsoft.com...
> Is there some sort of calculation to make a matrix export to pdf without
page breaks?
> I have
> 2 dynamic rows
> 1 dynamic column
> 1 value field
> Please help
> thanks
>|||Would you please post or send me your RDL? I will need it to understand your
situation better.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:8F4A4F3C-63DD-4F66-B24C-952BBF52A728@.microsoft.com...
> Report.PageWidth - Report.LeftMargin - Report.Right Margin = 8
> My body.width is 3.5
> Thanks
>
> "Bruce Johnson [MSFT]" wrote:
> > Please make sure that your report is setup as follows:
> > Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "AHH" <AHH@.discussions.microsoft.com> wrote in message
> > news:CE79F248-E5B9-4500-84C6-5CB91195BA6C@.microsoft.com...
> > > Is there some sort of calculation to make a matrix export to pdf
without
> > page breaks?
> > >
> > > I have
> > > 2 dynamic rows
> > > 1 dynamic column
> > > 1 value field
> > >
> > > Please help
> > >
> > > thanks
> > >
> >
> >
> >|||How many ReferringPhysicians do you have? If you are expecting the matrix to
fit to a specific size as column groups are added, this is not supported.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:8F4A4F3C-63DD-4F66-B24C-952BBF52A728@.microsoft.com...
> Report.PageWidth - Report.LeftMargin - Report.Right Margin = 8
> My body.width is 3.5
> Thanks
>
> "Bruce Johnson [MSFT]" wrote:
>> Please make sure that your report is setup as follows:
>> Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=>> Body.Width
>> --
>> Bruce Johnson [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "AHH" <AHH@.discussions.microsoft.com> wrote in message
>> news:CE79F248-E5B9-4500-84C6-5CB91195BA6C@.microsoft.com...
>> > Is there some sort of calculation to make a matrix export to pdf
>> > without
>> page breaks?
>> >
>> > I have
>> > 2 dynamic rows
>> > 1 dynamic column
>> > 1 value field
>> >
>> > Please help
>> >
>> > thanks
>> >
>>|||I made all of the column widths (the data) the same to no avail.
I also tried making the data conatained within the dynamic rows the same width in addition to making the dynamic column's data the same width and still get blank pages
from the documentation, the report should wrap to the next page
This only happens for PDF export - all other formats are fine
Still working on it
if you have anymore ideas please let me know - been at this for 30 hours now. :)
Later, allen|||I took this issue offline with AHH and was able to determine that a bug is
causing the problem.
ISSUE:
Periodically, blank pages are inserted into the a PDF rendering.
DISCUSSION:
The report that caused the problem contained a list that contained a matrix.
What appears to be occurring is that the list did not resize to the width of
the matrix - its width continued to expand until it was wider than the
report page width. At this point a blank page was inserted into the
rendering. If a workaround is discovered it will be posted on this thread. A
fix for this should appear in a future service pack or release.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"AHH" <AHH@.discussions.microsoft.com> wrote in message
news:CE79F248-E5B9-4500-84C6-5CB91195BA6C@.microsoft.com...
> Is there some sort of calculation to make a matrix export to pdf without
page breaks?
> I have
> 2 dynamic rows
> 1 dynamic column
> 1 value field
> Please help
> thanks
>

Matrix Counting and Totals

I have a report in matrix format. The weeks are across the top and the
calculated field is in the rows. I need to be able to count accounts that
have ordered for that week which I was able to do. I also need to count if
this is the first time the customer has ordered "ever" and if they are
re-ordering. A re-order is considered if they have ordered twice. Does
anyone have any suggestions on the best way to do this?Are you getting your data from SQL Server? If possible, I'd do the counting
in the query itself, not the report. It's a lot easier to do counts in SQL
than in a matrix.
If you do want to count in your report, you could use the InScope function,
and check if you are inscope for the account group.
A bit of pseudocode to show what I'm thinking
=IIF(InScope("AccountGroup"), runningvalue(fields!Order.Value), 0)
(Please verify syntax...)
Kaisa M. Lindahl Lervik
"Debbie Nelson" <Debbie Nelson@.discussions.microsoft.com> wrote in message
news:0CC9D925-B21D-4E0D-A59C-C1B9821F59FC@.microsoft.com...
>I have a report in matrix format. The weeks are across the top and the
> calculated field is in the rows. I need to be able to count accounts that
> have ordered for that week which I was able to do. I also need to count
> if
> this is the first time the customer has ordered "ever" and if they are
> re-ordering. A re-order is considered if they have ordered twice. Does
> anyone have any suggestions on the best way to do this?

Matrix column visibility

Hello,

I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5.

But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects.

I have RS 2005.

Thank you for any idea.

Jirka Nouza

Currently, the visibility of static matrix columns cannot be controlled. We are considering to lift this restriction in a future release.

-- Robert

|||

Well, nothing doing. Thank you for your replay.

Jirka

|||This would definitely be nice to have... is there any way to hack around this?

Matrix column visibility

Hello,

I have one column group and three static columns. I'd like to control static column visibility property depending on a field value. I.e. Hidden: =Fields!GroupId<>5.

But I'm not able to find visibility property in column object. Neither in properties explorer nor RDL documentation. I'm only able to set hidden property in textbox objects.

I have RS 2005.

Thank you for any idea.

Jirka Nouza

Currently, the visibility of static matrix columns cannot be controlled. We are considering to lift this restriction in a future release.

-- Robert

|||

Well, nothing doing. Thank you for your replay.

Jirka

|||This would definitely be nice to have... is there any way to hack around this?

Matrix - No data display "NaN"

Hello,

I have matrix object in reportin (SQL 2005 reporting services)

When in some field have no data it display NaN.

How can I change it ?

I try to use iif(my function = nothing.....) but didn't help

Hi there,

Here's a blog posting that may help

http://blogs.digineer.com/blogs/jasons/archive/2006/08/18/374.aspx

cheers,

Andrew