Articles

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.

2002-03-08

2,221 reads

Performance Comparison: Data Access Techniques

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.

2002-03-01

2,857 reads

How to Fix Inconsistent Metadata Errors

Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it.

5 (1)

2002-02-28

12,991 reads

Blogs

Getting Started on AWS RDS

By

I’m expanding my skill set into AWS in a big way. So, one of...

Daily Coping 1 Jun 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Setting Up GitHub Desktop (formerly GitHub for Windows)

By

When I started using Git, I first download GitHub for Windows. I went searching,...

Read the latest Blogs

Forums

Assignment Help

By dilipjadhav

I was wondering if anyone would be kind enough to help me with a...

Accuranker Keywords Ranking Tracker

By alexrory4650

Accuranker Keywords Ranking Tracker is a catchphrase rank tracker apparatus that values incredible exactness...

Best Tools For Marketing Of Your Content

By alexrory4650

While no content marketing tool can supplant a strong system and skilled people, having...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers