I get the following questions quite often and thought I gather my thoughts together in this blog post
Figure: Not sure if I should respond or remain silent
Many articles on the web, books and statistics tell us that “faster = better” and even more important: faster = more revenue.
For Google an increase in page load time from 0.4 second to 0.9 seconds decreased traffic and ad revenues by 20%.
For Amazon every 100 ms increase in load times decreased sales with 1%.
Also Google uses site speed in their web search ranking. So make sure to optimize your website for speed as per my other blog post.
Is Web Performance Optimization (WPO) something for you?
If you are stuck into Report Builder 2.0 world because you are still using SQL Server 2008 and not the shiny new SQL Server 2008 R2. Check out the following tip.
--> Report Builder 3.0 works only in conjunction with SQL Server 2008 R2
My problem
Bad: Boring data with numbers that are hard to compare - Sorting is on another column not shown here
Q1: Where do i get help for the expression syntax in the report designer?
Q2: How can I create a report template, so that I don't have to start from a blank report each time?
Q3: Is it possible to skin the Report server Website? I can make an asp.net page, but I think the Report Server page is probably adequate. Probably the better option is to use report services in Sharepoint?
Q
SSIS can export data into excel files, and SSRS can also do this. Which way is better / more appropriate in which circumstances?
Q1 How to trigger SSIS/SSRS jobs manually/on-demand without using the SQL Agent. How can I let end users trigger dtsx packages. Are there API hooks that I could run from a VBScript form (ideally) or perhaps .NET
Q2 I would like to know how you loop through different directory and upload files from various directories using SSIS. It will be great if you can give some demo.
