|
|
|
|
|
|
|
|
|
Data Driven Subscriptions Using the Null Provider
It may not be obvious, but the null provider is a clean and simple way to cache data for reports. Caching in turn leads to reports rendering a lot faster for users, with the only downside being that if you cache, you have latency (the data is stale). It's an easy technique to apply and worth doing in many cases.
|
|
|
|
Duration:
|
6
mins
2
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.33
out of 5
|
|
Publish Date:
|
February 17, 2010
|
|
|
|
About the Author
|
|
Devin (MCTS) is a Senior BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business...
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
Excellent idea on Quizzes!!
Suggestion: allow to answer more questions or stop at the first one or two.
Thanks,
Roman
|
|
|
Can you use this same caching method if there is more than one parameter for a report? For example, if you had a report that took in a year and a month, could you do a query that was select distinct year, month from date_table? then would you still get a performance increase when you selected any year or month?
|
|
Jeff Winkler on
3/22/2010
It wasn't obvious how to navigate to the subscription services administration to start.
|
|
|
I really like the quizzes at the end. Keeps me on my toes!
|
|
|
Instructor gives a good of the null subscription process, but does not indicate (with the exception of SSMS) what tool(s) he is using to create the null subscription.
|
|
|
very difficult to listen to
|
Must Be Logged In
|
|
|
|
|