SQL Server Magazine April 2009
[Features]
If SQL Server’s performance is suffering, you may be considering new equipment. These techniques can improve performance without that expense.
By Michael K. Campbell
Learn how to use the FixForwardedRecs stored procedure to find and remove forwarded records from heap tables.
By Lori Brown
Using T-SQL's CASE function, you can quickly transform numerical codes and other hard-to-decipher data into meaningful information.
By Bill McEvoy
Store BLOB data as files managed by the OS and reap the performance benefits now—with this walk-through of how to set up and configure SQL Server 2008’s FILESTREAM storage feature.
By Michael K. Campbell
[Editorial]
SQL Server shops are looking for ways to save money without cutting back on existing services or ongoing projects. They just want it all to happen with less money. So what are some of the best ways to cuts costs for a SQL Server installation?
By Michael Otey
In this down economy, we’re looking at better ways to bring DBAs content and analysis in multiple formats—magazines, web seminars, live events, conferences, virtual events, videos, blogs, and forums. We're reinventing the way we deliver content.
By Michele Crockett
[Reader to Reader]
SQL Server Management Studio (SSMS) lacks an easy-to-use tool to get detailed data about partitioned tables. To fill this gap, a reader has created two tools. One provides the data in a results grid, whereas the other provides the data in a report.
By Readers
[Solutions by Design]
Poolet shares the approach she uses when planning and managing a database project. This is project management for non-PMs: admins and developers without a PM, or IT pros who must build a data warehouse and act as their own PM.
By Michelle A. Poolet
[T-SQL Black Belt]
Itzik discusses four enhancements, including composable DML, the ability to declare and initialize variables in the same statement, compound assignment operators, and more reliable object dependency information.
By Itzik Ben-Gan
[SELECT TOP(X)]
New data-access options in VS 2008 and the .Net Framework 3.5 SP1 include LINQ to DataSet, ADO.Net Data Services, and SQL Server Data Services.
By Michael Otey
[Market Watch]
SQL Server and virtualization gurus from Quest Software, Microsoft, VMware, and Rochester General Health Systems offer their suggestions for running SQL Server in a virtual environment.
By Jeff James
|
