SQL Server Magazine

		Options
A New Day for BI Microsoft's Bill Baker talks to us about SQL Server 2005's business intelligence (BI) transformation. We also show you how to make database maintenance easier, determine whether you should use implicit or explicit index keys, and more!		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Building Better BI in SQL Server 2005

Microsoft General Manager of SQL Server Business Intelligence Bill Baker spoke to SQL Server Magazine about the new BI features in SQL Server 2005 and how they can help you streamline delivery of business-critical information.
By Editors 

Data Mining Reloaded

The data-mining functionality in SQL Server 2005 is greatly expanded and highly flexible. Take a look at what you can expect in--and do with--the new Analysis Services.
By Alexei Bocharov  , et al.

Hide Database Changes

Maintaining and changing a database schema is hard when you have applications that depend on the original schema. But you can use stored procedures and views to hide your database changes from your applications--and give you a cleaner schema to work with.
By Mark D. Scott 

Avoid Using Trace Flag 2861 to Cache Zero-Cost Query Plans

Trace flag 2861 causes SQL Server to cache query plans for trivial queries that have a cost of zero or close to zero.
By Brian Moran 

Fn_virtualfilestats() Function Reports Reads and Writes

Find out what the number of reads and writes reported by the fn_virtualfilestats() system function mean.
By Brian Moran 

Forcing a Parallel Plan

Can you force SQL Server to use a parallel plan instead of a serial one?
By Brian Moran 

Last_Batch in Master..Sysprocesses

What does it mean when you see a value of 1900-01-01 00:00:00.000 in master..sysprocesses' last_batch column?
By Brian Moran 

Stored Procedure Runtime

A particular stored procedure generally runs in 5 seconds; however, when multiple users run the query at the same time, it takes nearly five times as long to run all the queries.
By Brian Moran 

A Tale of Two CLRs

IBM's DB2 UDB 8.2 may have gotten .NET integration first, but Microsoft and SQL Server 2005 got it right.
By Michael Otey 

Implicit or Explicit Index Keys

Why would you add redundant columns to a nonclustered index? Find out in this examination of index behavior.
By Kalen Delaney 

Practicing Data Porting

After you understand how to properly structure tables for keyword lookups, you need to transfer the old data to a new database. Learn how by walking through this example that shows you how to port data from a keyword array into new, normalized tables.
By Michelle A. Poolet 

Nonexistent Ranges

Anybody can find a group of dates that exist, but you'll need to do some deep thinking to create a query that returns a group of nonexistent date ranges.
By Itzik Ben-Gan 

PIVOT on Steroids

Build a better PIVOT operator by encapsulating workarounds in a powerful procedure that uses dynamic SQL.
By Itzik Ben-Gan 

Letters, February 2005

Readers write in about SQL Server Magazine's 2004 Salary and Industry survery and more!
By Readers 

New Products, February 2005

Check out the latest SQL Server-related products.
By Dawn Cyr 

ADO.NET 2.0

News about data-access technology has taken a back seat to server news lately. But here are six important changes in ADO.NET 2.0.
By Michael Otey 

Active/Passive vs. Active/Active Clustering

Microsoft's Richard Waymire explains the difference between these two types of failover clustering.
By Microsoft's SQL Server Development Team 

Building Dynamic IN Lists

Microsoft's Patrick Conlan shows how to construct a variable that contains an SQL query, then execute it via sp_executesql or EXEC().
By Microsoft's SQL Server Development Team