Check Recovery Model

Hello,
How can i get information about the recovery model of one
database without using the Enterprise Manager?
What table should i query to get this information?
Best RegardsYou can get the recovery model for a database with:
SELECT DATABASEPROPERTYEX('<database name>','Recovery')
for example:
SELECT DATABASEPROPERTYEX('Northwind', 'Recovery')
--
Jacco Schalkwijk
SQL Server MVP
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:449b01c42b91$3600c950$a501280a@.phx.gbl...
> Hello,
> How can i get information about the recovery model of one
> database without using the Enterprise Manager?
> What table should i query to get this information?
> Best Regards|||To add to Jacco's response, the recovery model is also available via
sp_helpdb.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:449b01c42b91$3600c950$a501280a@.phx.gbl...
> Hello,
> How can i get information about the recovery model of one
> database without using the Enterprise Manager?
> What table should i query to get this information?
> Best Regards

Check Performance for queries

Hi,
I have two queries which will yield me the same result.
Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
check the performance of both these queries and select one.
I have heard of performance plans... all those things. I am not
familiar to it. But I would like to learn.
pls guide me
Thanks
kiranAs a starter you might use the SET STATISTICS option (see BOL). Further
on you can view execution plans by selecting the option in the query
menu of Query Analyzer.
M|||Hi
You may want to look at using SQL profiler to do this see duration, reads,
writes and CPU used. You may want to see Tony's blog casts on
http://www.sqlserverfaq.com/ for an introduction to SQL Profiler. Also check
out the topic "Query Tuning", "Analyzing Queries" and "Analyzing a Query" in
books online on who to display query plans and statistics.
John
"kiran" wrote:

> Hi,
> I have two queries which will yield me the same result.
> Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
> check the performance of both these queries and select one.
> I have heard of performance plans... all those things. I am not
> familiar to it. But I would like to learn.
> pls guide me
>
> Thanks
> kiran
>|||Mark he query you wnat to examine and hit CTRL-L in QA.
HTH, jens Suessmeyer.|||Jens wrote:
> Mark he query you wnat to examine and hit CTRL-L in QA.
> HTH, jens Suessmeyer.
>
Thanks a lot Guys, I will give it a try.|||Hi
Also look at running DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE to clear
out the buffer and procedure cache.
http://www.transactsql.com/html/DBC...EANBUFFERS.html
http://www.transactsql.com/html/DBC...EPROCCACHE.html
John
"kiran" wrote:

> Jens wrote:
> Thanks a lot Guys, I will give it a try.
>

Check Performance for queries

Hi,
I have two queries which will yield me the same result.
Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
check the performance of both these queries and select one.
I have heard of performance plans... all those things. I am not
familiar to it. But I would like to learn.
pls guide me
Thanks
kiran
As a starter you might use the SET STATISTICS option (see BOL). Further
on you can view execution plans by selecting the option in the query
menu of Query Analyzer.
M
|||Hi
You may want to look at using SQL profiler to do this see duration, reads,
writes and CPU used. You may want to see Tony's blog casts on
http://www.sqlserverfaq.com/ for an introduction to SQL Profiler. Also check
out the topic "Query Tuning", "Analyzing Queries" and "Analyzing a Query" in
books online on who to display query plans and statistics.
John
"kiran" wrote:

> Hi,
> I have two queries which will yield me the same result.
> Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
> check the performance of both these queries and select one.
> I have heard of performance plans... all those things. I am not
> familiar to it. But I would like to learn.
> pls guide me
>
> Thanks
> kiran
>
|||Mark he query you wnat to examine and hit CTRL-L in QA.
HTH, jens Suessmeyer.
|||Jens wrote:
> Mark he query you wnat to examine and hit CTRL-L in QA.
> HTH, jens Suessmeyer.
>
Thanks a lot Guys, I will give it a try.
|||Hi
Also look at running DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE to clear
out the buffer and procedure cache.
http://www.transactsql.com/html/DBCC...ANBUFFERS.html
http://www.transactsql.com/html/DBCC...PROCCACHE.html
John
"kiran" wrote:

> Jens wrote:
> Thanks a lot Guys, I will give it a try.
>

Check Performance for queries

Hi,
I have two queries which will yield me the same result.
Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
check the performance of both these queries and select one.
I have heard of performance plans... all those things. I am not
familiar to it. But I would like to learn.
pls guide me
Thanks
kiranAs a starter you might use the SET STATISTICS option (see BOL). Further
on you can view execution plans by selecting the option in the query
menu of Query Analyzer.
M|||Hi
You may want to look at using SQL profiler to do this see duration, reads,
writes and CPU used. You may want to see Tony's blog casts on
http://www.sqlserverfaq.com/ for an introduction to SQL Profiler. Also check
out the topic "Query Tuning", "Analyzing Queries" and "Analyzing a Query" in
books online on who to display query plans and statistics.
John
"kiran" wrote:
> Hi,
> I have two queries which will yield me the same result.
> Is there a way in SQL Server(Query analyzer or Enterprise Manager) to
> check the performance of both these queries and select one.
> I have heard of performance plans... all those things. I am not
> familiar to it. But I would like to learn.
> pls guide me
>
> Thanks
> kiran
>|||Mark he query you wnat to examine and hit CTRL-L in QA.
HTH, jens Suessmeyer.|||Jens wrote:
> Mark he query you wnat to examine and hit CTRL-L in QA.
> HTH, jens Suessmeyer.
>
Thanks a lot Guys, I will give it a try.|||Hi
Also look at running DBCC DROPCLEANBUFFERS and DBCC FREEPROCCACHE to clear
out the buffer and procedure cache.
http://www.transactsql.com/html/DBCC%20DROPCLEANBUFFERS.html
http://www.transactsql.com/html/DBCC%20FREEPROCCACHE.html
John
"kiran" wrote:
> Jens wrote:
> > Mark he query you wnat to examine and hit CTRL-L in QA.
> >
> > HTH, jens Suessmeyer.
> >
> Thanks a lot Guys, I will give it a try.
>

chart slows report render to crawl in Report Manager

I've searched the forums on this issue, haven't really found the answer.
I have several nifty little sales reports which crunch a ton of data quite
efficiently and render in just a few seconds in Report Manager. I've pushed
as much of the data processing back to the server as possible, use a stored
procedure (with parameters) in a shared datasource, don't return unneccessary
data, all that. It works great.
When I first developed the reports, I continued generating my charts (which
use the same data as the reports, just grouped differently) in Excel and
pasting them in as images. Now I want to stop that nonsense and use the SSRS
charts. I fooled around with the charting function and got a reasonable
facimile of my Excel charts, two per report, which use their own separate
stored procedures and the same shared datasource.
Now, reports that used to render in 5-8 seconds may take 1-5 MINUTES. Help!
It's definitely the charts--taking them back out fixes the problem.
I have complete control over the datasources--would it make more sense to
use non-shared sources, or to create totally separate shared sources? I saw
a post that recommended "making data calls non-synchronous," but I have no
idea how to do that.
Thanks for any suggestions.On further investigation, it appears that deleting EITHER ONE of the charts
brings the rendering time down almost to the same time as no chart at all.
It's apparent that having MULTIPLE charts on a page multiplies the rendering
time exponentially (I'm gonna tell Edward Tufte!)
This happens whether I put the charts side-by-side (preferred) or one above
the other on the page--they just take FOREVER to render.
Anybody...?|||RS 2005
I'm not sure how you mean your question about grouping. The charts each
have one grouping level, the table below them has three. Each component
(table, each chart separately) renders in roughly 5 seconds by itself. When
I put all three of them in the same report, the rendering time goes up to
well over one minute. Weird.
"Bruce L-C [MVP]" wrote:
> Hmmm, I don't know, I have a report with 3 charts and I don't see this
> issue. Do you have any grouping, anything special? Also, RS 2000 or RS 2005?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "elinde" <elinde@.discussions.microsoft.com> wrote in message
> news:301D52EC-E38F-423D-9A01-B4386A282B36@.microsoft.com...
> > On further investigation, it appears that deleting EITHER ONE of the
> > charts
> > brings the rendering time down almost to the same time as no chart at all.
> > It's apparent that having MULTIPLE charts on a page multiplies the
> > rendering
> > time exponentially (I'm gonna tell Edward Tufte!)
> >
> > This happens whether I put the charts side-by-side (preferred) or one
> > above
> > the other on the page--they just take FOREVER to render.
> >
> > Anybody...?
> >
>
>|||Is this deployed or in the IDE? If in the development environment try
deploying and see if that makes a difference in performance.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"elinde" <elinde@.discussions.microsoft.com> wrote in message
news:54603F35-85B8-405F-B979-DC03DD43AB16@.microsoft.com...
> RS 2005
> I'm not sure how you mean your question about grouping. The charts each
> have one grouping level, the table below them has three. Each component
> (table, each chart separately) renders in roughly 5 seconds by itself.
> When
> I put all three of them in the same report, the rendering time goes up to
> well over one minute. Weird.
> "Bruce L-C [MVP]" wrote:
>> Hmmm, I don't know, I have a report with 3 charts and I don't see this
>> issue. Do you have any grouping, anything special? Also, RS 2000 or RS
>> 2005?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "elinde" <elinde@.discussions.microsoft.com> wrote in message
>> news:301D52EC-E38F-423D-9A01-B4386A282B36@.microsoft.com...
>> > On further investigation, it appears that deleting EITHER ONE of the
>> > charts
>> > brings the rendering time down almost to the same time as no chart at
>> > all.
>> > It's apparent that having MULTIPLE charts on a page multiplies the
>> > rendering
>> > time exponentially (I'm gonna tell Edward Tufte!)
>> >
>> > This happens whether I put the charts side-by-side (preferred) or one
>> > above
>> > the other on the page--they just take FOREVER to render.
>> >
>> > Anybody...?
>> >
>>|||This is happening in deployment, unfortunately. The server is big, new &
fast--it's not that.
"Bruce L-C [MVP]" wrote:
> Is this deployed or in the IDE? If in the development environment try
> deploying and see if that makes a difference in performance.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "elinde" <elinde@.discussions.microsoft.com> wrote in message
> news:54603F35-85B8-405F-B979-DC03DD43AB16@.microsoft.com...
> > RS 2005
> >
> > I'm not sure how you mean your question about grouping. The charts each
> > have one grouping level, the table below them has three. Each component
> > (table, each chart separately) renders in roughly 5 seconds by itself.
> > When
> > I put all three of them in the same report, the rendering time goes up to
> > well over one minute. Weird.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Hmmm, I don't know, I have a report with 3 charts and I don't see this
> >> issue. Do you have any grouping, anything special? Also, RS 2000 or RS
> >> 2005?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "elinde" <elinde@.discussions.microsoft.com> wrote in message
> >> news:301D52EC-E38F-423D-9A01-B4386A282B36@.microsoft.com...
> >> > On further investigation, it appears that deleting EITHER ONE of the
> >> > charts
> >> > brings the rendering time down almost to the same time as no chart at
> >> > all.
> >> > It's apparent that having MULTIPLE charts on a page multiplies the
> >> > rendering
> >> > time exponentially (I'm gonna tell Edward Tufte!)
> >> >
> >> > This happens whether I put the charts side-by-side (preferred) or one
> >> > above
> >> > the other on the page--they just take FOREVER to render.
> >> >
> >> > Anybody...?
> >> >
> >>
> >>
> >>
>
>|||Hmmm, I don't know, I have a report with 3 charts and I don't see this
issue. Do you have any grouping, anything special? Also, RS 2000 or RS 2005?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"elinde" <elinde@.discussions.microsoft.com> wrote in message
news:301D52EC-E38F-423D-9A01-B4386A282B36@.microsoft.com...
> On further investigation, it appears that deleting EITHER ONE of the
> charts
> brings the rendering time down almost to the same time as no chart at all.
> It's apparent that having MULTIPLE charts on a page multiplies the
> rendering
> time exponentially (I'm gonna tell Edward Tufte!)
> This happens whether I put the charts side-by-side (preferred) or one
> above
> the other on the page--they just take FOREVER to render.
> Anybody...?
>

Chart does not display when Toolbar=False

I have a basic bar chart that runs fine on a local 32 bit server both within an IFRAME and within the reports manager. However, on another server that is brand new and clean install of SQL Server 2005 (64 bit) that same chart will run fine within reports manager but not through a direct link (whether in an IFRAME or not).

I narrowed the problem down to the parameter Toolbar=False. If I leave off that parameter, the report runs fine but includes the header. If I set the parameter to True, it also displays fine with a direct link. I can also specify Parameters=False and that works fine. However, no matter what I try, setting Toolbar=False returns a report (showing text in textboxes) but the chart itself returns as an image placeholder with the little red x.

Obviously, I do not want the user to see the toolbar within the application. I tried looking at the logs and event viewer for clues and found nothing.

Can someone please help?

Well it appears I have run across a bug: http://support.microsoft.com/?kbid=921405

Why would Microsoft not release this hotfix without having to call them if it is a known problem when not in anonymous mode and should have been included in the latest hotfix post-SP1 rollup release?

Does anyone know where I might can simply get this hotfix?

Changing Virtual Directories

Hello, I'm installing reporting services on a new sql server 2005 box. While
on the machine, I go to Reporting Services Configuration Manager, I'm trying
to create the report server virtual directory and report manager virtual
directory. My issue is that I don't want to create them on the sql box but
on another web server. I don't get an option to tell it to create a New
folder on anywhere put the sql server.
How can you do this?
Thanksyou have to install RS on this second server... and you have to pay for the
license...
you can use the first server to host the RS database, but you have to go
through the setup process for the new web server.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> Hello, I'm installing reporting services on a new sql server 2005 box.
> While
> on the machine, I go to Reporting Services Configuration Manager, I'm
> trying
> to create the report server virtual directory and report manager virtual
> directory. My issue is that I don't want to create them on the sql box
> but
> on another web server. I don't get an option to tell it to create a New
> folder on anywhere put the sql server.
> How can you do this?
> Thanks
>|||Are you sure that's how the licensing works? I thought you only had to pay
for additional licenses if you were doing it in a farm, or if your database
server was 1 cpu and the web server had 2 CPU.
So, If I run the setup on the web server then when i go into Reporting
Services Configuration Manager on the web server and select the database on
the sql server? Or do you do the configuration manager from the sql server.
Thanks
"Jeje" wrote:
> you have to install RS on this second server... and you have to pay for the
> license...
> you can use the first server to host the RS database, but you have to go
> through the setup process for the new web server.
> "Don" <Don@.discussions.microsoft.com> wrote in message
> news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > Hello, I'm installing reporting services on a new sql server 2005 box.
> > While
> > on the machine, I go to Reporting Services Configuration Manager, I'm
> > trying
> > to create the report server virtual directory and report manager virtual
> > directory. My issue is that I don't want to create them on the sql box
> > but
> > on another web server. I don't get an option to tell it to create a New
> > folder on anywhere put the sql server.
> > How can you do this?
> >
> > Thanks
> >|||On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
> Are you sure that's how the licensing works? I thought you only had to pay
> for additional licenses if you were doing it in a farm, or if your database
> server was 1 cpu and the web server had 2 CPU.
> So, If I run the setup on the web server then when i go into Reporting
> Services Configuration Manager on the web server and select the database on
> the sql server? Or do you do the configuration manager from the sql server.
> Thanks
> "Jeje" wrote:
> > you have to install RS on this second server... and you have to pay for the
> > license...
> > you can use the first server to host the RS database, but you have to go
> > through the setup process for the new web server.
> > "Don" <D...@.discussions.microsoft.com> wrote in message
> >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > > Hello, I'm installing reporting services on a new sql server 2005 box.
> > > While
> > > on the machine, I go to Reporting Services Configuration Manager, I'm
> > > trying
> > > to create the report server virtual directory and report manager virtual
> > > directory. My issue is that I don't want to create them on the sql box
> > > but
> > > on another web server. I don't get an option to tell it to create a New
> > > folder on anywhere put the sql server.
> > > How can you do this?
> > > Thanks
The licensing scheme that Jeje mentioned is correct (reference:
http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
link should help in terms of the Configuration process.
http://msdn2.microsoft.com/en-us/library/ms157293.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thanks, so I have a sql server but I don't want to install the reporting
services piece on the sql server (using the IIS installed on SQL box) because
I want people outside of the network to see the reports using the report
manager.
I believe that if I have it installed on the sql server then only people in
the office will be able to see it. So, sql server reporting servies is only
really every included in your purchase of sql server if you want to only
display the data with people logged onto your network?
Thanks
"EMartinez" wrote:
> On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
> > Are you sure that's how the licensing works? I thought you only had to pay
> > for additional licenses if you were doing it in a farm, or if your database
> > server was 1 cpu and the web server had 2 CPU.
> >
> > So, If I run the setup on the web server then when i go into Reporting
> > Services Configuration Manager on the web server and select the database on
> > the sql server? Or do you do the configuration manager from the sql server.
> >
> > Thanks
> >
> > "Jeje" wrote:
> > > you have to install RS on this second server... and you have to pay for the
> > > license...
> > > you can use the first server to host the RS database, but you have to go
> > > through the setup process for the new web server.
> >
> > > "Don" <D...@.discussions.microsoft.com> wrote in message
> > >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
> > > > Hello, I'm installing reporting services on a new sql server 2005 box.
> > > > While
> > > > on the machine, I go to Reporting Services Configuration Manager, I'm
> > > > trying
> > > > to create the report server virtual directory and report manager virtual
> > > > directory. My issue is that I don't want to create them on the sql box
> > > > but
> > > > on another web server. I don't get an option to tell it to create a New
> > > > folder on anywhere put the sql server.
> > > > How can you do this?
> >
> > > > Thanks
>
> The licensing scheme that Jeje mentioned is correct (reference:
> http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
> link should help in terms of the Configuration process.
> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||its a network and firewall issue.
you can install RS on the same box as SQL Server and open the HTTP door to
allow external users to access the server.
if you use ISA Server (or a firewall like this one) you can publish the
server easily on the internet.
"Don" <Don@.discussions.microsoft.com> wrote in message
news:B83002C5-DD7C-4220-818B-C796C2683889@.microsoft.com...
> Thanks, so I have a sql server but I don't want to install the reporting
> services piece on the sql server (using the IIS installed on SQL box)
> because
> I want people outside of the network to see the reports using the report
> manager.
> I believe that if I have it installed on the sql server then only people
> in
> the office will be able to see it. So, sql server reporting servies is
> only
> really every included in your purchase of sql server if you want to only
> display the data with people logged onto your network?
> Thanks
> "EMartinez" wrote:
>> On Oct 2, 8:06 pm, Don <D...@.discussions.microsoft.com> wrote:
>> > Are you sure that's how the licensing works? I thought you only had to
>> > pay
>> > for additional licenses if you were doing it in a farm, or if your
>> > database
>> > server was 1 cpu and the web server had 2 CPU.
>> >
>> > So, If I run the setup on the web server then when i go into Reporting
>> > Services Configuration Manager on the web server and select the
>> > database on
>> > the sql server? Or do you do the configuration manager from the sql
>> > server.
>> >
>> > Thanks
>> >
>> > "Jeje" wrote:
>> > > you have to install RS on this second server... and you have to pay
>> > > for the
>> > > license...
>> > > you can use the first server to host the RS database, but you have to
>> > > go
>> > > through the setup process for the new web server.
>> >
>> > > "Don" <D...@.discussions.microsoft.com> wrote in message
>> > >news:96C0591D-C166-47B1-AF47-21CE26772036@.microsoft.com...
>> > > > Hello, I'm installing reporting services on a new sql server 2005
>> > > > box.
>> > > > While
>> > > > on the machine, I go to Reporting Services Configuration Manager,
>> > > > I'm
>> > > > trying
>> > > > to create the report server virtual directory and report manager
>> > > > virtual
>> > > > directory. My issue is that I don't want to create them on the sql
>> > > > box
>> > > > but
>> > > > on another web server. I don't get an option to tell it to create
>> > > > a New
>> > > > folder on anywhere put the sql server.
>> > > > How can you do this?
>> >
>> > > > Thanks
>>
>> The licensing scheme that Jeje mentioned is correct (reference:
>> http://msdn2.microsoft.com/en-us/library/ms143238.aspx ). Also, this
>> link should help in terms of the Configuration process.
>> http://msdn2.microsoft.com/en-us/library/ms157293.aspx
>> Hope this helps.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>