sql Reporting services – report name
I have a report that runs nightly for daily invoices. It runs everyday using a subscription and places the report in a shared folder. It’s called “Daily Invoice Report”. How do I get the the Report Name “Daily Invoice Report” to also include the date that the report is for. This date is a parameter [...]

Answer Question   |  October 8, 2010  2:10 PM
SQL 2005 Database design, SQL 2005 Reporting Services, SQL Reports

SQL Server 2005 Performance optimiztion
I have the following setup, would like to know what’s best for log files, data files, indexes, tempdb files. Also, since the server is used solely for SQL 2005 Reporting Services, how many tempdb data files and tempdb log files should I create, also how many userdb data files and userdb log files. Want to [...]

Answer Question   |  December 4, 2009  4:24 PM
SQL 2005 Reporting Services, SQL Server 2005, SQL Server performance, Windows Server 2003