SQL Server Magazine June 2004
[Focus]
With SQL Server 2005 still on the distant horizon, how can you get the most out of your SQL Server 2000 system today? Dig into these seven valuable and often overlooked features.
By Brian Lawton
Everyone knows how views can bring information together and how they can drag down query performance. But materialized, or indexed, views--when used with care--can give your transactional database a big query-performance boost.
By Michelle A. Poolet
[Features]
Navigating OLAP cube data sometimes requires that you know MDX, but learning the syntax can be challenging. Logging MDX statements that Microsoft Excel generates is an easy way to collect example MDX statements so that you can learn how they work.
By John Lynn
[SQL Server Savvy]
Want to know how often SQL Server runs the auto update statistics option, or if the update has a negative effect on performance? Here's the answer...
By Brian Moran
Brian Moran presents some insights from SQL Server MVP, Linchi Shea, about usage-based costing tools and SQL Server.
By Brian Moran
Find out how to create an SQL batch to programmatically test whether SQL Server Agent is running a job.
By Brian Moran
The sp_reset_connection procedure runs when the OLE DB (or ODBC) connection pool grabs a connection that’s been released to the pool but is still active on SQL Server.
By Brian Moran
You can enable or disable the AUTO_CLOSE option by using the ALTER DATABASE command.
By Brian Moran
[Editorial]
In the software realm, the first 20 percent of the work produces 80 percent of the project, but the remaining 20 percent of the project takes 80 percent of the overall project’s time.
By Michael Otey
[Inside SQL Server]
Constructing useful search arguments can be tricky, but when you do it right, you can help the optimizer help your queries.
By Kalen Delaney
[Solutions by Design]
Supporting a bill-of-materials is a common but complex task. With careful modeling and an understanding of recursive relationships, you can avoid the redundancy and update problems that often occur in a database that supports this architecture.
By Michelle A. Poolet
[T-SQL Black Belt]
Recursive CTEs let you use short, efficient code to manipulate single and multi-parent hierarchies. With a bit of sophistication, you can even provide solutions to the toughest hierarchical problems—detecting cycles and sorting siblings.
By Itzik Ben-Gan
[Exploring XML]
There’s more to Yukon’s XML improvements than just the XML data type. The new TYPE directive makes your FOR XML queries more powerful, flexible, and efficient.
By Rich Rollman
[New Products]
Check out the latest SQL Server-related new and improved products.
By Dawn Cyr
[SELECT TOP(X)]
SQL Server’s built-in management tools are powerful, but they have limitations. However, third party tools can make up the difference. Here are three heterogeneous management tools to manage SQL Server, Oracle, and DB2 databases.
By Michael Otey
|
