SQL Server Magazine December 2007
[Features]
Find out if virtualizing your SQL Server deployment is the right option for your organization.
By Alan Sugano
If you want to be able to see the complexity and size of queries, consider implementing estimated execution plans in your organization.
By Tyler Chessman
[Columns]
DBAs get answers to basic Structured Query Language (SQL) questions on the difference between FILLFACTOR = 0 and FILLFACTOR = 100; ISNULL and NULLIF; clustered index and nonclustered index; % used as wildcard and % used as operator; TRUNCATE and DELETE.
By Pinalkumar Dave
[Editorial]
Many organizations have adopted running multiple VMs on a single hardware platform as a server consolidation method, but virtualization isn’t the only solution. Find out how virtualization and multiple SQL server instances compare.
By Michael Otey
[Reader to Reader]
Although SQL Server offers a variety of string functions, it doesn't have a function that strips out non-alphanumeric characters. Here's a user-defined function to fill that gap.
By Readers
LoadTraceFileToTable loads the data from a trace file into a trace table so that you can easily sort and analyze that data.
By Eli Leiba
It used to be difficult to answer questions such as "When was the last time this job was run?" and "What jobs will be affected if we bring down the system for maintenance?" With the cspJobMonitor procedure that's no longer the case.
By Readers
[Inside SQL Server]
SQL Server 2005 doesn’t limit plan-cache size but still provides ways to control it. Learn how to keep an eye on cache size and tricks to trim down a bloated cache to improve performance.
By Kalen Delaney
[Solutions by Design]
Dimensional roles can play many different parts in an accumulating snapshot fact table. Find out how dimensional role-playing can benefit your star schema.
By Michelle A. Poolet
[T-SQL Black Belt]
This two-part series promises to shed some light on the way reads behave in different scenarios, as well as the consistency level you should expect in each scenario.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products.
By Jeff James
[SELECT TOP(X)]
Virtualization can prevent server sprawl—but SQL Server workloads can be tricky to virtualize. Here are answers to your virtualization FAQs that can help you tackle this intriguing task.
By Michael Otey
[Review]
HP PolyServe Database Utility for SQL Server offers simplified consolidation and failover for SQL Server but requires careful planning to install.
By Ron Talmage
[Cover Story]
Learn which Microsoft and third-party products will have the tools you need to stay on top of SQL Server development, administration, and business intelligence (BI) challenges in the coming year.
By Megan Bearly , et al.
[Sqlmag.com Community Dialog]
The SQL Server Magazine forums have been especially lively lately, with a thoughtful exchange about backup and restore and readers’ feedback. Find out how to join the conversation.
By Anne Grubb
[Eye on BI]
Annoyed by the fact that SSRS restricts the structure of the MDX queries you’re allowed to write? We've got a workaround or two that can help.
By Chris Webb
|
