SQL Server Magazine December 2002
[Focus]
You know you can predict future database storage needs by evaluating past usage, but how do you collect the historical statistics? Here's a 2-step process that lets you do it yourself.
By Greg A. Larsen
[Features]
Information about setting up server-requested SSL encryption in a clustered SQL Server environment is hard to come by. But these clear steps pave the way to a straightforward implementation.
By Gary Zaika
With limited time and resources, what’s a call-center team to do when CPU utilization is about to go over the top? A system redesign that included replication slashed overhead, boosted performance, and guaranteed scalability for years.
By Alexander Stamenkovich , et al.
[SQL Server Savvy]
Learn a technique for correlating a SQL Server SPID with the UMS responsible for managing its execution.
By Brian Moran
If you're running multiple, concurrent, large data-load operations, you might be getting reduced throughput. Learn a workaround that can significantly improve your performance.
By Brian Moran
Learn how to use a command-line tool to schedule a move of a virtual SQL Server instance from one clustered node to another.
By Brian Moran
[Editorial]
Even with Microsoft’s ramped-up security efforts, your systems are still only as secure as you make them. Here are some common-sense measures you can take to safeguard your SQL Server systems.
By Michael Otey
[Reader to Reader]
If you frequently have to calculate percentages of data that meet a condition, here's a T-SQL solution that can help streamline the process.
By Readers
If you're engrossed in finding missing identity values, here's a query that performs the search more quickly.
By Readers
Securing DTS packages is important, but it can be difficult if many users have access to the packages. Here are two techniques for restricting user access to DTS.
By Readers
[SQL Seven]
There are more ways to stop SQL Server than you might think.
By Michael Otey
[Inside SQL Server]
In its quest for the best query-execution plan, the optimizer sometimes works too hard. Learn how to determine when the optimizer is recompiling stored procedures unnecessarily and what to do about it.
By Kalen Delaney
[Mastering Analysis]
Analysis applications frequently contain confidential information. Here's a scalable way to use MDX to determine which users can access sensitive information.
By Russ Whitney
[T-SQL Black Belt]
Sometimes, T-SQL just can't solve a problem alone without severe performance penalties. When this happens, consider using indexed views to rev up performance.
By Itzik Ben-Gan
[Answers from Microsoft]
What constitutes a covered query? What’s the definition of a covering index? And when do you use one, or the other, or both? Microsoft’s SQL Server development team sheds light on one reader’s question.
By Microsoft's SQL Server Development Team
Each of these two ways to extract data from many tables has its pros and cons. Choose the approach that works best for your situation.
By Microsoft's SQL Server Development Team
Numbering rows incrementally from a SELECT statement is difficult, but it can be done. Here are some suggestions from Microsoft’s SQL Server Development Team.
By Microsoft's SQL Server Development Team
If you avoid these setup traps, you can run SQL Server 2000 and 6.5 on the same machine.
By Microsoft's SQL Server Development Team
Would using a trigger to launch your DTS package streamline your process? One of these three methods likely fits your scenario.
By Microsoft's SQL Server Development Team
[Exploring XML]
If you need to map columns to elements or attributes, chain relationship annotations, specify columns as unique keys, or signal that an element or attribute isn’t in the database, you need to use these annotations.
By Rich Rollman
[Letters]
Readers encourage people not to wait for Windows .NET Server before developing and deploying .NET applications and explore set-based solutions.
By Various Authors
[New Products]
Check out the latest SQL Server-related new and improved products.
By Carolyn Mader
|
