SQL Server Magazine May 2000
| |
|
Options |
SQL Server 2000
SQL Server 2000 builds on the firm foundation of SQL Server 7.0. PLEASE NOTE: The authors based their SQL Server 2000 articles for this issue on pre-Beta 2 versions, so you might notice some differences between Beta 2 and the behavior or interfaces we describe in this issue. In particular, please note that the indexed views feature will be available only in SQL Server 2000 Enterprise Edition. However, you can install Enterprise Edition on NT 4 Server and Windows 2000 (Win2K) Server. You don't need NT 4.0 Enterprise or Win2K Advanced Server.
|
|
• Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts
|
|
[Focus]
With SQL Server 2000, you can create indexes on views, a function that promises to make query-writing easier while making your applications and queries run faster.
By Kalen Delaney
SQL Server 2000 leverages the SQL Server 7.0 foundation and adds some plumbing and wiring. But in many ways, SQL Server is the finished basement, the huge deck, and the home movie studio you've always wanted.
By Brian Moran
Check out SQL Server 2000's XML enhancements and explore an example of how you can extract data from SQL Server 2000 as XML, format the data, then use that data in your application.
By Paul Burke
[Features]
Create a reusable project that periodically downloads and processes Web data.
By Christian Gilstrap
Despite your best efforts and SQL Server 7.0's improved transaction contention management, you can't always avoid deadlocks, particularly when multiple indexes exist on a table. Use these tips to determine the best workaround for your situation.
By David Erickson
[Editorial]
Think twice before hiring an application service provider.
By Michael Otey
[Reader Challenge]
How can Christina send output to a table from statements that fail to return output as a proper result set?
By Tibor Karaszi
[Reader to Reader]
Use Outlook and a 2-way pager to keep in touch with your database.
By Allan Wessels
[SQL Server Q&A]
Richard Waymire answers questions about troubleshooting SELECT statements, listing PC software, searching for CRLFs, and more.
By Richard Waymire
[SQL Seven]
ADO’s flexibility gives you more ways to shoot yourself in the foot while you’re writing applications. Here’s a list of the seven most common errors that I see in ADO coding.
By Michael Otey
[SQL Server/Office Integration]
Knowing how to use T-SQL's control-of-flow statements empowers Access developers to write code that operates conditionally depending on user input.
By Rick Dobson
[Inside SQL Server]
Here are tips for directly accessing system tables when you can't get the information you need any other way.
By Kalen Delaney
[Mastering Analysis]
SQL Server 2000 includes an all-new version of OLAP Services, whose new name, Analysis Service 8.0, reflects its new capabilities.
By Russ Whitney
[Solutions by Design]
Knowing how the business system works will help you build a reliable, well-functioning and long-lasting database.
By Michelle A. Poolet
[Certifiably SQL]
To master SQL Server 7.0's automated administrative tasks, you need to know how to configure alerts and set up operators.
By Michael D. Reilly
|
