Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples
Search:
What's New - What's Hot
More Categories for .NET Framework .NET Framework (1709)
More Categories for .Net Framework 2.0 .Net Framework 2.0 (362)
More Categories for ADO.NET ADO.NET (411)
More Categories for AJAX AJAX (755)
More Categories for ASP.Net ASP.Net (22022)
More Categories for ASP.NET 2.0 ASP.NET 2.0 (4640)
More Categories for C-Sharp C-Sharp (18146)
More Categories for Exchange Server Exchange Server (55)
More Categories for SQL Server SQL Server (5027)
More Categories for Visual Basic.Net Visual Basic.Net (5931)
More Categories for Visual C# .NET Visual C# .NET (80)
More Categories for Visual C++ .NET Visual C++ .NET (7625)
More Categories for Visual Source Safe Visual Source Safe (42)
More Categories for Visual Studio 2005 Visual Studio 2005 (2053)
More Categories for Visual Studio.Net Visual Studio.Net (1856)
More Categories for WAP WAP (783)
Listings for WCF WCF (1047)
More Categories for Web Web (47)
More Categories for Web Services Web Services (403)
More Categories for Windows Windows (768)
Listings for WPF WPF (2193)
Listings for WWF WWF (305)
More Categories for XML XML (63)
More Categories for XML And .NET XML And .NET (1204)


The SqlCacheDependency Class     
Total Hits: 155  |  Today: 0Author: Luke Stratman      Rating:  
Read Reviews | Write Review |  Your Rating: 

Luke Stratman shows how and why to use the SqlCacheDependency class.

It's hard for me to pin down a favorite feature in the 2.0 version of the .NET framework. Is it generics? Or maybe built-in configuration file encryption? How about the updated configuration classes? It's a tough choice. But there's no doubt about my favorite example of what makes .NET 2.0 such a compelling development platform: the SqlCacheDependency class. It does a brilliant job of illustrating just how well the vario...

Using SQL Cache Dependencies     
Total Hits: 177  |  Today: 0Author: Scott Mitchell      Rating:  
Read Reviews | Write Review |  Your Rating: 

The simplest caching strategy is to allow cached data to expire after a specified period of time. But this simple approach means that the cached data maintains no association with its underlying data source, resulting in stale data that is held too long or current data that is expired too soon. A better approach is to use the SqlCacheDependency class so that data remains cached until its underlying data has been modified in the SQL database. This tutorial shows you how....

Article-Synchronize Distributed Object Cache with SQL Server 2005     
Total Hits: 169  |  Today: 0Author: Iqbal M Khan.      Rating:  
Read Reviews | Write Review |  Your Rating: 

NCache lets you cache data closer to your application in the middle-tier so you can reduce expensive trips to the database. This in turns significantly speeds up your application. It also makes it more scalable because the load on your database is reduced allowing it to handle a larger number of clients without any hardware upgrades.

However, when you cache data, you're actually creating a copy of it outside of your database. This introduces the risk that data in your database would be mo...

Build Your Own Analysis Services Cache-Warmer in Integration Services     
Total Hits: 178  |  Today: 0Author: cwebbbi.spaces.live      Rating:  
Read Reviews | Write Review |  Your Rating: 

Cache-warming is one of the most neglected performance-tuning techniques for Analysis Services: perhaps it seems too much like cheating? Yet almost everyone knows how much difference there can be executing a query on a cold cache and a warm cache so there should be no excuse not to be doing it, especially if you know what queries your users are likely to be running in advance. AS2005's caching mechanism is more complex than I can describe here (or than I can describe full stop - although I hear ...

The Power of SQL CASE Statements     
Total Hits: 132  |  Today: 0Author: Scott Mitchell      Rating:  
Read Reviews | Write Review |  Your 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 ...

Report Execution Caching I: SQL Server Management Studio Perspective     
Total Hits: 183  |  Today: 0Author: William Pearson      Rating:  
Read Reviews | Write Review |  Your 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...

Report Execution Caching II: Report Manager Perspective     
Total Hits: 197  |  Today: 0Author: William Pearson      Rating:  
Read Reviews | Write Review |  Your 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...

Invalidating an ASP.NET Web Application Cache Item from SQL Server (Part 1 – A simple example)     
Total Hits: 126  |  Today: 0Author: Donny Mack      Rating:  
Read Reviews | Write Review |  Your Rating: 

We have seen over and over again the question, "How can I invalidate a cache item in my ASP.NET Web application when a change is made in my database?" Well, this article will demonstrate one way to accomplish this using triggers, a console application, and dependency files. As the title implies this is a two part article, the second part (or example) will be much more complicated and will span many different types of technologies including HttpHandlers, SQL Server, and enabling SQL Server itself...

SqlDependency – Proof of Concept (Part II)     
Total Hits: 135  |  Today: 0Author: Donny Mack      Rating:  
Read Reviews | Write Review |  Your Rating: 

The ASP.NET Cache supports invalidation based on key, timestamp, or file dependencies, e.g. file changes and the cache item is invalidated. A frequent question is how to support this from a database, e.g. we're caching a DataSet, or some other reperesentation of data, in the ASP.NET Cache and the table(s) representing that data changes; thus the data in the Cache is no longer valid. This sample shows using some simple code that will automatically wire up a trigger on a table and call an extended...

Invalidating an ASP.NET Web Application Cache Item from SQL Server (Part 1 – A simple example)     
Total Hits: 170  |  Today: 0Author: Donny Mack      Rating:  
Read Reviews | Write Review |  Your Rating: 

We have seen over and over again the question, "How can I invalidate a cache item in my ASP.NET Web application when a change is made in my database?" Well, this article will demonstrate one way to accomplish this using triggers, a console application, and dependency files. As the title implies this is a two part article, the second part (or example) will be much more complicated and will span many different types of technologies including HttpHandlers, SQL Server, and enabling SQL Server itself...

ASP.NET Caching: SQL Cache Dependency With SQL Server 2000     
Total Hits: 58  |  Today: 0Author: Muhammad Mosa      Rating:  
Read Reviews | Write Review |  Your 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....

Utility Belt: Caching Demo SQLserver     
Total Hits: 180  |  Today: 0Author: Charles Carroll      Rating:  
Read Reviews | Write Review |  Your Rating: 

To make applications faster and provide an added benefit to using UtilityBelt all functions internally use DataTables to fetch data from the database support caching in an easy transparent fashion by setting properties instead of changing the actual library calls....

SYSK 333: What Query Plans Are Cached in SQL Server?     
Total Hits: 133  |  Today: 0Author: Irena Kennedy      Rating:  
Read Reviews | Write Review |  Your Rating: 

It’s well known that, to improve performance, SQL Server caches query execution plans in memory. But would you like to know what query execution plans are currently in the cache?...

Caching Data for Better Performance     
Total Hits: 254  |  Today: 0Author: Marco Bellinaso      Rating:  
Read Reviews | Write Review |  Your Rating: 

In every site or web-based application there is some data that doesn’t change very often, which is requested very frequently by a lot of end users. Examples are the list of article categories, or the e-store’s product categories and product items, the list of countries and states, and so on. The most common solution to increase the performance of your site is to implement a caching system for that type of data, so that once the data is retrieved from the data store once, it will be kept in memor...

SQL Express Dependency Caching     
Total Hits: 269  |  Today: 0Author: asp.net      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Express dependency caching is easier to set up because SQL Express natively supports change notifications. You do not need to run special command line utilities to prepare the database because notifications are automatically generated by SQL Express. Moreover, the SqlCommand class inherently supports dependency caching. Simply instantiate the SqlCacheDependency class with a SqlCommand object and then use the Response object's AddCacheDependency method to add the SqlCacheDependency object to ...

Setting Up SQL Server 7/2000 Dependency Caching     
Total Hits: 217  |  Today: 0Author: asp.net      Rating:  
Read Reviews | Write Review |  Your 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....

Analyzing SQL Server 2000 Data Caching     
Total Hits: 343  |  Today: 0Author: Tom Pullen      Rating:  
Read Reviews | Write Review |  Your Rating: 

One of SQL Server 2000’s main selling points is its ease-of-use and simplicity. You can install it out of the box and use it pretty much without making many configuration changes. In terms of the product’s use of memory, there are some settings you can change, for example, how much memory to use, whether to dynamically allocate it, and so on. Otherwise, there isn’t a lot you can do in terms of memory tuning. But you may well find yourself in a situation where you want to know what tables and ind...

Using SQL Cache Dependency     
Total Hits: 351  |  Today: 0Author: Wei-Meng Lee      Rating:  
Read Reviews | Write Review |  Your Rating: 

Caching has long been recognized as one of the more effective ways to improve your ASP.NET web applications. However, one particular caching feature that was dearly missing in ASP.NET 1.x was SQL cache dependency. SQL cache dependency is the ability to invalidate a database cache if data in a table is changed. In ASP.NET 2.0, Microsoft has, much to the joy of developers, added the new SQL cache dependency feature. In this article, I will discuss SQL cache dependency in ASP.NET 2.0, as well as di...

Introduction into Caching in SQL Server 2000     
Total Hits: 198  |  Today: 0Author: ExtremeExperts.com      Rating:  
Read Reviews | Write Review |  Your 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?...

Interact with SQL Server's Data and Procedure Cache     
Total Hits: 265  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your 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 ...



Disclaimer - Privacy
© 2002-2015 DevASP.net