SQL Server Magazine January 2000
[Focus]
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
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
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
[Features]
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
[Columns]
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
The Transact SQL (T-SQL) language provides options for controlling SQL Server’s behavior on an individual-connection basis.
By Kalen Delaney
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
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
Store session information on a Web server easily with Session and Application variables.
By Ken Spencer
[Lab Reports]
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
[Departments]
The latest TPC results
By Michael Otey
Is the introduction of XML in SQL Server a good thing?
By Stephen Wynkoop
The winner and answer to last month's reader challenge plus this month's question.
By Tibor Karaszi
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
Answers from Microsoft
By Richard Waymire
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
[Mastering OLAP]
OLAP Services’ performance tradeoffs occur between cube build time and query time. Here’s how to optimize OLAP performance.
By Russ Whitney
|
