Can I inherited from a template report?

I must make many report in my project.

All the reports must have header of company name and footer of page number.

Can I desgin a template custom report, then all reports in my project are inherited from it?

This is very easy to do if you are developing your reports in Visual Studio. The templates for reports are stored at the following path:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject\

You can create a template report and save it in this location, and then when you want to use it, from within your report project, click on the 'Project' menu option, and select 'Add New Item...'. When the dialog opens, you should see all .rdl files located in the above directory.

Hope that helps - Dan

Can anyone recommend the best resource for performance tuning a SQL cluster?

I have a couple clusters (each with eight processors total, and 16 GB RAM
total), but am not getting the performance desired. I "inherited" these, I
didn't build them. Can anyone recommend any resources on tuning the cluster
and tuning the SQL service for the best performance?
The Cluster itself has no bearing on performance. You would tune the DB's
just like any other. The only exception is possibly the amount of ram you
use if you have a multi-instance cluster. See here for a start:
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
http://www.sql-server-performance.co...showcontig.asp Understanding
DBCC SHOWCONTIG
Andrew J. Kelly SQL MVP
"Adam Freden" <Adam.Freden@.cpsa-rbha.org> wrote in message
news:uUH3lnnmEHA.3356@.TK2MSFTNGP14.phx.gbl...
> I have a couple clusters (each with eight processors total, and 16 GB RAM
> total), but am not getting the performance desired. I "inherited" these,
I
> didn't build them. Can anyone recommend any resources on tuning the
cluster
> and tuning the SQL service for the best performance?
>
|||Just my two cents. Clusters are almost always built on advanced storage
technology (Except for SCSI-based clusters, which are evil). As such, the
performance of the storage device comes into play. If you find the system
is suffering from I/O limitations, you may need to dig into the SAN
performance and tuning to solve your problems. I would start with the links
Andrew sent and only go after SAN tuning once you have found and fixed all
your other performance issues.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23jH67KomEHA.3100@.TK2MSFTNGP10.phx.gbl...
> The Cluster itself has no bearing on performance. You would tune the DB's
> just like any other. The only exception is possibly the amount of ram you
> use if you have a multi-instance cluster. See here for a start:
>
> http://www.microsoft.com/sql/techinf...perftuning.asp
> Performance WP's
> http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
> http://www.sql-server-performance.co...ance_audit.asp
> Hardware Performance CheckList
> http://www.sql-server-performance.co...mance_tips.asp
> SQL 2000 Performance tuning tips
> http://www.support.microsoft.com/?id=q224587 Troubleshooting App
> Performance
>
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
> Disk Monitoring
> http://www.sql-server-performance.co...showcontig.asp
Understanding[vbcol=seagreen]
> DBCC SHOWCONTIG
>
> --
> Andrew J. Kelly SQL MVP
>
> "Adam Freden" <Adam.Freden@.cpsa-rbha.org> wrote in message
> news:uUH3lnnmEHA.3356@.TK2MSFTNGP14.phx.gbl...
RAM[vbcol=seagreen]
these,
> I
> cluster
>