Articles

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

13,055 reads

Optimizing Stored Procedures To Avoid Recompiles

One of the most overlooked areas in optimizing SQL Server and Transact-SQL is the recompilations of stored procedures. A database getting thousands of recompiles an hour will suffer in performance and show short term blocking that will affect the database users. This article by Randy Dyess shows you some of the ways you can avoid stored procedure recompiles.

3.67 (3)

2002-02-26

22,265 reads

Blogs

ASF 032: Jennifer Stirrup interview

By

Introduction Jennifer Stirrup is a data strategist and technologist, Microsoft Data Platform Most Valuable...

SQL Server Express Size Limit

By

My Pluralsight course for new SQL Server DBAs   (Needs to upgrade to a...

Daily Coping 2 Jul 2020

By

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

Read the latest Blogs

Forums

Adding NOT NULL to column with existing rows causes page bloat

By timoq

Hi, I'd like to know why the page count is almost exactly doubled for...

Stretch database

By mtz676

Is there anything similar to a stretch database in mysql where an on-premise mysql...

Partitioning Heaps

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Partitioning Heaps

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers