How many result-rows does mssql return should be used asynchronous method to use mssql cur

How many result-rows does mssql return should be used asynchronous method to use mssql cursor, can get the best performance in any time in any result offset?

i want to make the cursor fast in any time whatever how many results returnedi didnt understand what xactly you meant by your first line but for this
>>i want to make the cursor fast in any time whatever how many results returned

there some optional parameters when you declare a cursor..for xample :
BOL has a good reference about it..look under 'DECLARE CURSOR'

Transact-SQL Extended Syntax
DECLARE cursor_name CURSOR
[ LOCAL | GLOBAL ]
[ FORWARD_ONLY | SCROLL ]
[ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ]
[ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ]
[ TYPE_WARNING ]
FOR select_statement
[ FOR UPDATE [ OF column_name [ ,...n ] ] ]

you can use LOCAL, FORWARD_ONLY, READ_ONLY etc options to make it faster..

hth|||nono, i means the command like this:

sp_configure 'cursor threshold', xxx( a number, -1 = all synchronous, 0 = all asynchronous)

How many pages did ReportingService.Render method generate?

Hi,
I use SQL Server Reporting service SOAP API to render a report into a PDF
file. The method that I use is ReportingService.Render.
Now we are trying to know how many pages we have in the PDF file by Render
method. How can I retrieve number of generated page from reporting service?
Any help would be appreciated,
MaxHello Max,
Based on my scope, it does not seem there is parameter you could get the
page number from the output of rendering. You may need to use your own
count to count the page rendered by using device information settings:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_soapapi_dev_8bld.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you Peter for help.
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:U7qMWncNGHA.128@.TK2MSFTNGXA01.phx.gbl...
> Hello Max,
> Based on my scope, it does not seem there is parameter you could get the
> page number from the output of rendering. You may need to use your own
> count to count the page rendered by using device information settings:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_soapapi_dev_8bld.asp
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

How linear regression choose his regressor ?

I would like to understand the algorithm that the linear regression method uses to choose the regressors in the model from a list of possible regressors.

I think that it is different from the common methods used in statistics like stepwise, forward or backward.

Laura Lerner

When you build the model using the wizard, all continuous input columns are flagged as regressors.

You can check this by looking at the Modeling Flags property of each input column in the designer.

(edit) Jamie points out to me that the modeling flags only indicate potential regressors. The actual regressors are determined by the internals of the algorithm. We have no public documentation available on that process, but we can aim to provide more detail in future docs or whitepapers.

|||

I would like to know how the algorithm works, whether there are parameters I can change to influence the results.

Laura Lerner

|||

Laura Lerner wrote:

I would like to know how the algorithm works, whether there are parameters I can change to influence the results.

Laura Lerner

If you wish to make a specific input column a regressor for linear regression, you can do that by changing the Modeling Flag property of that column to Regressor.

I am wondering if there is a specific reason that you would want to influence the choice of regressors rather than explicitly setting them. That would be good to know, to inform our future plans.

Thanks

|||

For my purposes I would like to see the p values associated with the regressors so that I can decide which variables to include or not based on them, myself. Furthermore, in order not to run into a problem of multicollinearity it would be useful to see a correlation matrix as part of regression analysis and computed Variance Inflation Factors would definitely help as well. If we are providinga wish list, also at least a graph of samples of residuals would be great to have.

Best Regards,

|||

Thanks! I am quite happy to take wishes. Whether or when I can grant them is a different matter, but the more information we have on what people want - and, very importantly, why - the better.

I have had a number of requests for computed Variable Inflation Factors.

Feel free to contact me offline donald_dot_farmer_at_microsoft_dot_com if you want to discuss potential features and business cases in more detail.

Thanks

|||You can use the FORCE_REGRESSOR parameter to guarantee that the algorithm will use a particular regressor, regardless of the algorithm used to determine applicability. The target of FORCE_REGRESSOR does have to be marked as a regressor though.|||

I am building several automatic linear regressions using code and not the interface.

I give to the model hundreds variables it can choose and the result is a linear regression with very few variables.

I would like first to understand how it chooses the variables and whether there are parameters that I can use to influence the number of variables the linear regression will choose.

I used for many year SAS and there I know that I can use parameters like the significance level, number of variables to include, etc...

Laura Lerner

How i should show toolbar

Hi group,
First time i am using reportservice.render method to render the report in my
aspx page. Here is the code snippet
result = rs.Render(report,"HTML4.0",null,null,paramValue,credentials,null,out
encoding,out mimetype,out paramvalues,out warning,out streamidsh.SessionId = rs.SessionHeaderValue.SessionId;
Response.BinaryWrite(result);
by doing so i am getting all the pages on the same aspx page and no tool
baar is shown. I also tried by passing toolbar = true in device info string
but no result.
So what i should do to show the toolbar .
Thanks
SandeepHi group,
i find this in msdn
If you render a report to HTML using the Render method, you cannot use the
report viewer toolbar as you can with a report that is rendered using URL
access. However, the Toolbar device information setting still affects the
appearance of the report. If you set Toolbar to a value of true, the report
server only renders the first page of the HTML report. If you set the value
to false, the report server renders all pages into a single Web page, using
<HR> tags as page delimiters.
Is there any work around.
Please help me out
Sandeep Garg
"Sandeep" <sandeep.garg@.approva.net> wrote in message
news:%23BBQR999EHA.3988@.TK2MSFTNGP11.phx.gbl...
> Hi group,
> First time i am using reportservice.render method to render the report in
> my aspx page. Here is the code snippet
> result => rs.Render(report,"HTML4.0",null,null,paramValue,credentials,null,out
> encoding,out mimetype,out paramvalues,out warning,out streamidsh.SessionId
> = rs.SessionHeaderValue.SessionId;
> Response.BinaryWrite(result);
> by doing so i am getting all the pages on the same aspx page and no tool
> baar is shown. I also tried by passing toolbar = true in device info
> string but no result.
> So what i should do to show the toolbar .
> Thanks
> Sandeep
>|||The toolbar is only available via URL access. If you are getting a rendered
report using the webservice, you will have to implement your own toolbar.
"Sandeep" <sandeep.garg@.approva.net> wrote in message
news:uTbKJl%239EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Hi group,
> i find this in msdn
> If you render a report to HTML using the Render method, you cannot use the
> report viewer toolbar as you can with a report that is rendered using URL
> access. However, the Toolbar device information setting still affects the
> appearance of the report. If you set Toolbar to a value of true, the
> report server only renders the first page of the HTML report. If you set
> the value to false, the report server renders all pages into a single Web
> page, using <HR> tags as page delimiters.
> Is there any work around.
> Please help me out
> Sandeep Garg
> "Sandeep" <sandeep.garg@.approva.net> wrote in message
> news:%23BBQR999EHA.3988@.TK2MSFTNGP11.phx.gbl...
>> Hi group,
>> First time i am using reportservice.render method to render the report in
>> my aspx page. Here is the code snippet
>> result =>> rs.Render(report,"HTML4.0",null,null,paramValue,credentials,null,out
>> encoding,out mimetype,out paramvalues,out warning,out
>> streamidsh.SessionId = rs.SessionHeaderValue.SessionId;
>> Response.BinaryWrite(result);
>> by doing so i am getting all the pages on the same aspx page and no tool
>> baar is shown. I also tried by passing toolbar = true in device info
>> string but no result.
>> So what i should do to show the toolbar .
>> Thanks
>> Sandeep
>>
>|||Thaks for the suggestion.
Can u give me some clue how to implement my own toolbar. From where i got
the total page count and all the other required stuff.
Sandeep
"FNDS" <absolutelynospam@.nodomain_.com> wrote in message
news:exk34%23%239EHA.3616@.TK2MSFTNGP11.phx.gbl...
> The toolbar is only available via URL access. If you are getting a
> rendered report using the webservice, you will have to implement your own
> toolbar.
> "Sandeep" <sandeep.garg@.approva.net> wrote in message
> news:uTbKJl%239EHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Hi group,
>> i find this in msdn
>> If you render a report to HTML using the Render method, you cannot use
>> the report viewer toolbar as you can with a report that is rendered using
>> URL access. However, the Toolbar device information setting still affects
>> the appearance of the report. If you set Toolbar to a value of true, the
>> report server only renders the first page of the HTML report. If you set
>> the value to false, the report server renders all pages into a single Web
>> page, using <HR> tags as page delimiters.
>> Is there any work around.
>> Please help me out
>> Sandeep Garg
>> "Sandeep" <sandeep.garg@.approva.net> wrote in message
>> news:%23BBQR999EHA.3988@.TK2MSFTNGP11.phx.gbl...
>> Hi group,
>> First time i am using reportservice.render method to render the report
>> in my aspx page. Here is the code snippet
>> result =>> rs.Render(report,"HTML4.0",null,null,paramValue,credentials,null,out
>> encoding,out mimetype,out paramvalues,out warning,out
>> streamidsh.SessionId = rs.SessionHeaderValue.SessionId;
>> Response.BinaryWrite(result);
>> by doing so i am getting all the pages on the same aspx page and no tool
>> baar is shown. I also tried by passing toolbar = true in device info
>> string but no result.
>> So what i should do to show the toolbar .
>> Thanks
>> Sandeep
>>
>>
>|||Hmm. I haven't tackled creating my own toolbar to show a rendered report.
If someone has and is willing to share, please post a sample or URL...
Thx
"Sandeep" <sandeep.garg@.approva.net> wrote in message
news:%23gB0X$F%23EHA.2112@.TK2MSFTNGP10.phx.gbl...
> Thaks for the suggestion.
> Can u give me some clue how to implement my own toolbar. From where i got
> the total page count and all the other required stuff.
> Sandeep
> "FNDS" <absolutelynospam@.nodomain_.com> wrote in message
> news:exk34%23%239EHA.3616@.TK2MSFTNGP11.phx.gbl...
>> The toolbar is only available via URL access. If you are getting a
>> rendered report using the webservice, you will have to implement your own
>> toolbar.
>> "Sandeep" <sandeep.garg@.approva.net> wrote in message
>> news:uTbKJl%239EHA.3120@.TK2MSFTNGP12.phx.gbl...
>> Hi group,
>> i find this in msdn
>> If you render a report to HTML using the Render method, you cannot use
>> the report viewer toolbar as you can with a report that is rendered
>> using URL access. However, the Toolbar device information setting still
>> affects the appearance of the report. If you set Toolbar to a value of
>> true, the report server only renders the first page of the HTML report.
>> If you set the value to false, the report server renders all pages into
>> a single Web page, using <HR> tags as page delimiters.
>> Is there any work around.
>> Please help me out
>> Sandeep Garg
>> "Sandeep" <sandeep.garg@.approva.net> wrote in message
>> news:%23BBQR999EHA.3988@.TK2MSFTNGP11.phx.gbl...
>> Hi group,
>> First time i am using reportservice.render method to render the report
>> in my aspx page. Here is the code snippet
>> result =>> rs.Render(report,"HTML4.0",null,null,paramValue,credentials,null,out
>> encoding,out mimetype,out paramvalues,out warning,out
>> streamidsh.SessionId = rs.SessionHeaderValue.SessionId;
>> Response.BinaryWrite(result);
>> by doing so i am getting all the pages on the same aspx page and no
>> tool baar is shown. I also tried by passing toolbar = true in device
>> info string but no result.
>> So what i should do to show the toolbar .
>> Thanks
>> Sandeep
>>
>>
>>
>