|
|
|
|
|
| | Total Hits: 211 | Today: 0 | Author: asp.net | Rating:  |
| | 
SQL Server 7/2000 dependency caching requires you to run some setup scripts that build the cache tables ASP.NET will monitor for changes. For this purpose the .NET Framework 2.0 provides a utility called aspnet_regsql.exe.
You do not need to have SQL Server 7/2000 installed in order to follow these steps. The same scripts and legacy dependency caching implementation (next lesson) will work with SQL Express.... |
| | Total Hits: 0 | Today: 0 | Author: rusanu | Rating:  |
| |
Query Notifications is the SQL Server feature that allows a client to subscribe to notifications that are sent when data in the database changes irrelevant of how that change occurs. I have talked before about how Query Notifications works in the article The Mysterious Notification. This feature was designed specifically for client side cache invalidation: the applications runs a query, gets back the result and stores it in the cache. Whenever the result is changed because data was updated, the ... |
| | Total Hits: 128 | Today: 0 | Author: Scott Mitchell | Rating: |
| |
As developers creating data-driven Web applications, we've all written more than our fair share of SQL statements. If I had a nickel for every SELECT statement or UPDATE statement I've written in my six years as a Web developer, I'd be a rich man. Despite the familiarity with SQL that many Web developers have, one of the lesser known SQL tools is the CASE statement. The CASE statement is a wily little fellow that can be added to both the SELECT portion of a SELECT statement as well as the ORDER ... |
| | Total Hits: 177 | Today: 0 | Author: William Pearson | Rating: |
| |
This article is a member of the series MSSQL Server Reporting Services. The series is designed to introduce MSSQL Server Reporting Services (“Reporting Services”), presenting an overview of its features, with tips and techniques for real-world use. For more information on the series in general, please see my initial Database Journal article, A New Paradigm for Enterprise Reporting. For the software components, samples and tools needed to complete the hands-on portion of this article, see BlackBe... |
| | Total Hits: 54 | Today: 0 | Author: Muhammad Mosa | Rating: |
| |
As time passes, the data source may change in response to other actions. However, if your code uses caching, you may remain unaware of the changes and continue using out-of-date information from the cache. To help mitigate this problem, ASP.NET supports cache dependencies. Cache dependencies allow you to make a cached item dependent on another resource so that when that resource changes the cached item is removed automatically.... |
| | Total Hits: 193 | Today: 0 | Author: ExtremeExperts.com | Rating: |
| |
This topic has been in my minds for quite some time now. Just thought to get them into a understandable article for public use ... Well, most of the DBA's and many programmers of SQL Server should have heard of the terms data cahe and procedure cahe in conjunction with SQL Server. These are the primary building blocks or parts of the caching mechanism we all talk about. But what is this cache on first place?... |
| | Total Hits: 259 | Today: 0 | | Rating: |
| |
As you work with SQL Server you have probably heard of the terms data cache and procedure cache and may have wondered what exactly a cache was. SQL Server is configure to use a pool of memory of the server and it will allocate the majority of this memory pool to hold both data pages that have been read and the compiled execution plans for all Transact-SQL statements. It is this dynamic pool of memory that is being referred to and the data cache and procedure cache, keep in mind that in versions ... |
| | Total Hits: 2 | Today: 0 | Author: Harshit Vyas | Rating:  |
| |
Among all of .NET's good features caching is one of my favorites. Caching is really very easy to understand. It's concept is that if we need to fetch the data multiple times from SQL Server or from any file then it will cause a reduction of performance as we are retrieving the same data multiple times from the database or a file so why retrieve the same data again and again we can just store that data in our cache object.... |
| | Total Hits: 1 | Today: 0 | Author: Malcolm Sheridan | Rating: |
| |
Whenever I think of performance with ASP.NET, the first thing that comes to mind is caching. Simply put caching is an in memory storage of objects that enables the application to read and write data to memory.... |
| | Total Hits: 3 | Today: 0 | Author: Joydip Kanjilal | Rating: |
| |
Caching is an essential feature of ASP.NET that reduces latency and the network traffic by storing frequently used data and pages in the Cache for quick retrieval later; hence greatly boosting the application’s performance. We have had a detailed look at the concepts of Caching in the first part of this series of articles on Caching in ASP.NET. This article presents Data Caching, a feature of ASP.NET that allows you to store your data in the cache memory for faster retrieval. It also discusses t... |
| | Total Hits: 66 | Today: 0 | Author: Malcolm Sheridan | Rating: |
| |
Whenever I think of performance with ASP.NET, the first thing that comes to mind is caching. Simply put caching is an in memory storage of objects that enables the application to read and write data to memory. ASP.NET has several different varieties of caching features. This article will shine a light on a little known feature of ASP.NET 3.5 called SQL Cache Dependency. SQL Cache Dependency has been around since SQL Server 2000, but back then ASP.NET was limited as far as it had a polling mechan... |
| | Total Hits: 142 | Today: 0 | Author: Atif Shehzad | Rating: |
| |
The cache management mechanism plays an important role in performance of any system. Like any reliable DBMS, SQL Server enjoys a sophisticated cache management system for optimized performance without the need for any user intervention. There are ways to add a plan or data to the SQL Server cache or to remove a plan or data from SQL Server cache, but these techniques are only recommended for testing or troubleshooting purposes. Keeping in mind the importance of the cache mechanism, how could one... |
| | Total Hits: 160 | Today: 0 | Author: aakanksh | Rating: |
| |
To create this article I have refered a book on reporting services by the name "SQL Server 2005 Reporting Services in Action". The following article is my understanding of the concept of caching in reporting services. Report Server does processing in two stages:
* Execution
* Rendering.
During the execution stage, the Report Server retrieves the required report data, combines the resulting dataset with the report layout information, and generates the report’s intermediate format... |
| | Total Hits: 182 | Today: 0 | Author: Ray Barley | Rating: |
| |
If you take advantage of caching reports in SSRS, the cache expiration can be based on a time limit (e.g. 30 minutes) or a schedule (e.g. expire at midnight). We have a situation where we refresh our data warehouse weekly and want to cache reports until the next weekly load. Occasionally we will have to rerun a portion of the weekly data load and when this happens we need to expire all cached reports since the underlying data has changed. We have looked around in SQL Server Management Studio ... |
|
|
|
|
|
|
|
|
|
|
|
|
|