SQL Server Magazine October 2002
[Focus]
In an exclusive interview with SQL Server Magazine, Distinguished Architect Peter Spiro shares what's in the future for the SQL Server engine.
By Brian Moran
[Features]
Analysis Services doesn’t include a client tool for querying, reporting, or analyzing data, so unless you write a custom client browser, you have to find a commercial application. But which one? This review will help you choose the right tool.
By Aspirity's OLAP Team
The Database Hammer, a SQL Server 2000 Resource Kit tool, gives you the power to stress-test your database under the most grueling conditions. Couple it with some performance monitor counters for even better performance data.
By Joseph Isaac Sack
[SQL Server Savvy]
Learn how to write a script that checks for the existence of an index on a particular table without directly accessing the system tables.
By Brian Moran
Learn which two Performance Monitor counters let you specifically track the amount of work that SQL Server performs.
By Brian Moran
If you're wondering what maintenance tasks you should schedule regularly, check out the SQL Server 2000 Operations Guide.
By Brian Moran
[Editorial]
How do you deal with a backup time window that’s closing—whether you want it to or not—and a backup security window that you need to keep closed at all times?
By Michael Otey
[Reader to Reader]
A reader shares a tip for avoiding pop-up error messages when you alter the syntax of code that includes a cscript command.
By Readers
Learn how to set a new default directory for data and transaction log files in SQL Server 2000.
By Readers
A reader shares a stored procedure that he used to search for columns in his database.
By Readers
[SQL Seven]
Here's a quick introduction to fixed server roles in SQL Server 2000 and 7.0.
By Michael Otey
[Inside SQL Server]
To design indexes for your tables, you need to know your queries intimately. The answers to these 9 questions will show you the pattern to follow.
By Kalen Delaney
[Mastering Analysis]
When you're analyzing terabytes of data, the performance of your CROSSJOIN() functions can make--or break--your application's overall performance.
By Russ Whitney
[Solutions by Design]
You can use extended properties in SQL Server 2000 to make a business metadata repository that will benefit everyone in your organization.
By Michelle A. Poolet
[T-SQL Black Belt]
With many calendars in use and varying ways of expressing times and dates around the world, keeping everything straight in your calculations could be a nightmare—but it doesn't have to be.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team explains how to ensure that routine and custom changes to a stored procedure are made at the subscriber during replications in SQL Server 2000 and 7.0.
By Microsoft's SQL Server Development Team
Do multiple developers have access to your database? Corrupted and missing data can be the result. Microsoft’s SQL Server development team describes three scenarios for controlling database access that will satisfy all database users.
By Microsoft's SQL Server Development Team
[Exploring XML]
Current technologies still lack adequate support for building Web applications, so your best bet is to use the best tool for the job.
By Rich Rollman
[Letters]
Readers ask about using ownership chains with NT logins and how to recreate a fact table from Analysis Services cube data.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
