SQL Server Magazine February 2007
[Focus]
What's important to consider in designing a database? For optimal performance, you need to be mindful about three interrelated factors: indexing, maintenance, and statistics. Here's some advice to get you started in the planning process.
By Kimberly L. Tripp
[Features]
The Native XML Web Services feature in SQL Server 2005 removes dependency on IIS to help you create robust, feature-rich enterprise database solutions. Here’s how the feature works, how to implement it, and how to code client applications.
By Roman Rehak
Occasionally, the SQL Server optimizer chooses a plan that isn't the most efficient one possible. Itzik shows how he figured out how to produce the lowest-cost plan for a particular type of query.
By Itzik Ben-Gan
Create better reports faster by using templates, custom assemblies, and these layout and performance tips.
By Andrew Potter
Looking for a way to script database schema without buying a third-party tool? Here’s a Windows console-mode utility that uses SMO to script tables, stored procedures, views, user-defined functions (UDFs), and other schema objects within your databases.
By John Jakob
[Editorial]
SQL Server started out a couple of steps behind other database platforms, but with new and future releases focused on change management and end-to-end business insight, Microsoft plans to finish ahead of the competition.
By Michael Otey
[Reader to Reader]
If you discover a loop in a stored procedure, you might find that the code iterates thousands of times before the loop exits. One way to improve the performance of loops is to optimize variable handling.
By Readers
[Inside SQL Server]
Some SQL Server behaviors change in subtle ways from version to version. Learn about three such changes that might surprise you.
By Kalen Delaney
[Letters]
By Editors
[New Products]
Check out new and improved SQL Server-related products.
By Blake Eno
[SELECT TOP(X)]
SQL Server 2005 offers various types of data replication depending on your data replication needs.
By Michael Otey
[Tool Time with Kevin Kline]
With SQL Server 2005, it can be tough to create a stress test that actually stresses your system. Here’s a tool that can generate a load sufficient to overwork almost any system.
By Kevin Kline
[Review]
Spotlight on SQL Server lets you see real-time SQL Server activity, making it easy for you to monitor the performance of your databases.
By Michael K. Campbell
[SQL Server Product Review]
Check out DatabaseSpy if you routinely work in different database environments and need a multidatabase design and management tool.
By Michael Cassens
[Industry Briefings]
Our editors share insights from their conversations with InterSystems Corporation, GridApp Systems, and Network Appliance.
By Editors
[PTO for the Rest of Us]
Is your I/O subsystem not properly equipped to handle the workload you're placing on it? Adding a faster system probably won't magically solve the problem. You need to change your thinking process.
By Brian Moran
|
