SQL Server Magazine

		Options
Performance Filled with performance tips on database design, application building, and SQL Server tuning, this is the essential guide to maximizing SQL Server performance.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Nine Ways to Optimize SQL Server 6.5 Queries

What a difference an index can make! You can get better performance by configuring everything from your hardware to your database options. Here are my top nine ways to performance-tune SQL Server 6.5.
By Morris Lewis 

Tuning SQL Server 6.5 for High-Performance Queries

An application’s performance depends on your database’s design and query structure. A few simple tweaks of your database and queries can give you optimal performance.
By Morris Lewis 

Which is Faster: Index Access or Table Scan?

It can be difficult to determine whether a table scan or an index will provide better query performance. The answer depends in part, on the percentage of rows returned, but another important factor is whether you use a clustered or nonclustered index.
By Dusan Petkovic 

Defining Databases and Tables with Access Projects

Access 2000’s new data definition capabilities for SQL Server databases will empower your organizations to build SQL Server applications faster and more easily than ever before.
By Rick Dobson 

Certifiably SQL: Login Security

Security is a matter that concerns database designers and administrators alike. A database's design must address security issues, which can influence table design or the use of views and stored procedures to restrict user access to the tables.
By Michael D. Reilly 

Inside SQL Server: Controlling Query Behavior

The Transact SQL (T-SQL) language provides options for controlling SQL Server’s behavior on an individual-connection basis.
By Kalen Delaney 

Solutions By Design: Accessing SQL Server Data

If everyone in a company who needs information can get to the corporate data in a timely manner and can understand what the data means, everyone can be more responsive to customer and industry challenges and can do a better job.
By Michelle A. Poolet 

SQL Server/Office Integration: SQL Server Views with Access 2000

With the release of Access 2000, the time is right to start using Access to develop solutions for SQL Server. The time is right also for a column targeting SQL Server development for Access developers, particularly those using Access 2000.
By Rick Dobson 

Web Dev: Using Session and Application Variables

Store session information on a Web server easily with Session and Application variables.
By Ken Spencer 

Lab Reports: SQL-Programmer IX

Sylvain Faust’s SQL-Programmer, a third-party, general-purpose SQL Server utility development tool, provides cross-platform capability for any combination of SQL Server, Sybase Adaptive Server, and Oracle.
By Ron Talmage 

Editorial: Benchmarking Redux

The latest TPC results
By Michael Otey 

Industry Defrag: Here Comes XML

Is the introduction of XML in SQL Server a good thing?
By Stephen Wynkoop 

Reader Challenge: Silence, Please

The winner and answer to last month's reader challenge plus this month's question.
By Tibor Karaszi 

Reader to Reader: The Optimal Dynamic String

Here’s an efficient way to write a query to retrieve members with an attribute belonging to all members in one or many groups.
By

SQL Server Q & A

Answers from Microsoft
By Richard Waymire 

SQL Seven: Office 2000/SQL Server Integration

Microsoft Office has always had strong BackOffice connectivity. Office 2000 continues this trend with strong SQL Server connectivity. Here are the seven coolest SQL Server integration features in Office 2000.
By Michael Otey 

OLAP Performance

OLAP Services’ performance tradeoffs occur between cube build time and query time. Here’s how to optimize OLAP performance.
By Russ Whitney