Server Performance

Solution Search:
article on shrinking your database to death, I tested and proved that there are some performance implications when a database file grows during a transaction. I then provided... More...
Jun 25, 2009
database backup technique involves backing up the database to a disk on the same server. This is fine, provided the disk is a separate physical RAID array from the one that... More...
Jun 22, 2009

Since the release of Hyper-V, Microsoft has continued its commitment to server virtualization by releasing new software products that are optimized for just... More...

Jun 15, 2009

Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions... More...

Jun 10, 2009

Transparent Data Encryption (TDE) is a new feature in SQL Server 2008 designed to encrypt your database files, database backups and temporary... More...

Jun 9, 2009

Organizations banking on SQL Server to protect and manage their internal data are in for a treat when they upgrade to SQL... More...

Jun 3, 2009

SQL Server 2008 introduces the concept of the sparse column, which is a type of column that... More...

Jun 2, 2009
might be long running, such as an SPID that never issues a commit. Paused or high-performance with database mirroring can cause delays. The former causes transactions to not... More...
May 27, 2009

The new FILESTREAM functionality in SQL Server 2008 lets you configure a varbinary(max) column so that the actual data is stored on... More...

May 25, 2009

With Windows Server 2008 Hyper-V and the upcoming release of R2, Microsoft is driving full speed ahead... More...

May 19, 2009

The next version of SQL Server will be getting a new name, added logical processor support and a bevy of new data... More...

May 11, 2009

With any text search, performance is the most important factor that should be addressed. What approach is going to run... More...

May 7, 2009
One of the new Transact-SQL features implemented in SQL Server 2008 is the GROUPING SETS option in the GROUP BY clause of a SELECT statement... More...
May 5, 2009
This chapter excerpt from Learning SQL Server 2008 Reporting Services, by Jayaram Krishnaswamy, is printed with permission from... More...
May 1, 2009
on the disk. Database Schema View, the other view, is hierarchical in the manner of SQL Server Management Studio. There is a list of top-level objects, such as tables or stored... More...
Apr 27, 2009
of handling larger workloads, or in other words, making it bigger and better. With SQL Server 2008, there are two distinct paths you can take to scaling: up and out. Both are... More...
Apr 21, 2009
that retrieves data from a remote OLE DB data source or bulk loads data into a SQL Server table. In such cases, you can use the OPENROWSET function in Transact-SQL to pass a... More...
Apr 16, 2009
Although the changes in replication when moving from SQL Server 2000 to 2005 were radically different, the enhancements for SQL Server 2008 are... More...
Apr 13, 2009

So you've decided to upgrade to SQL Server 2008 – what now? Let's take a look at some of the basics steps to ensure a... More...

Apr 9, 2009
while increasing the scalability and availability associated with their SQL Server infrastructures. Although it would seem natural for most organizations to... More...
Apr 3, 2009
one of the most anticipated management features in SQL Server 2008. It bolsters SQL Server performance by allowing DBAs to establish resource limits and priorities on processor and... More...
Apr 1, 2009
When planning a SQL Server upgrade -- such as an upgrade to SQL Server 2008 -- one of the most important aspects to... More...
Mar 30, 2009
in an effort to reduce costs. This is especially true in large organizations with SQL Server infrastructures, where IT staffs often find themselves running many... More...
Mar 25, 2009
This short guide features expert advice for those looking to learn more about SQL Server consolidation, with details on when (and when not) to consolidate, consolidation... More...
Mar 25, 2009
Let's say you've just spent many hours designing a SQL Server 2005 Analysis Services (SSAS) unified dimensional model for the sales managers in... More...
Mar 23, 2009
Server Clustering Solutions
IPControl - automated IP Address Management & DNS/DHCP server configuration by BT Diamond IP
and service levels by automating IPAM and DNS/DHCP server configuration. IPControl is a next-generation software system that enables service providers and...
Server Clustering Whitepapers
Rethinking Server Virtualization: Breaking Performance and Manageability Barriers by HP, Intel, & VMware
support for virtualized environments. Server virtualization is an ever more important tool for reducing cost, increasing availability, and enhancing business...
Sun and VMware Solutions Guide for Windows Server Consolidation by Sun Microsystems, Inc.
up with VMware to provide a solution for Windows Server Consolidation. Together these two companies have created a unified solution that encompasses the expansive storage...
Top 10 Reasons for Using Online Server Backup and Recovery by Iron Mountain Digital
businesses are turning to disk-based online server backup and recovery solutions as the most cost-effective fit for their requirements, when they have neither the volume...
Replicate with Integrity: Protecting VMware Data to Ensure Fast Recovery, Business Continuity by FalconStor Software
As organizations increasingly adopt server virtualization, they have begun to leverage remote replication as a means of increasing system availability. This...
Protecting Exchange by Double-Take Software
availability features of Microsoft Exchange Server can provide an end-to-end solution for Exchange protection. Read this white paper for me information. The combination of...