(Joe Chang) Microsoft SQL Server introduced parallel query processing capability in version 7.0. The purpose of parallel query execution is to complete a query involving a large amount of data more quickly than possible with a single thread on computers with more than one processor. Books Online and

(Kevin Cox and William Jones) SQL Server’s transaction log plays a critical role in replication and in the automatic roll-forward and rollback recovery process. This chapter explains how to use the operation codes to decipher a log and how to get detailed information about transactions in a log usin

(Muthusamy Anantha Kumar) Every corporation has a unique infrastructure environment. Let us consider a simple production, testing, and a development environment. The SQL scripts application, developed in a development environment will be tested in a QA environment and then moved to production on a p

(Rick Dobson) By now, most developers know that SQL Server and Microsoft .NET are a dynamic duo. The Microsoft .NET Framework is on its way to becoming an integral part of several important Microsoft server products, including SQL Server. Even now, developers can create SQL Server solutions through

(Bill Richmond) The general rule is to avoid using temp tables, usually in favor of derived tables or table variables, but there are times when it seems that nothing else will do the job. Or, maybe we just inherit complex code that already makes extensive use of temp tables. Frequently, query perfor

(Baya Pavliashvili) In the previous articles in this series, I introduced you to aggregate and system-related functions. This article continues to explore various types of built-in functions. I will walk you through the most useful functions that fall into date and time, math, and text function cate

Whenever a client application needs to send Transact-SQL to SQL Server, send it in the form of a stored procedure instead of a script or embedded Transact-SQL. Stored procedures offer many benefits.

(Russ Whitney and Tim Ramey) Have you ever needed to set up Analysis Services in a multidomain network environment? Have you needed to provide access to your Analysis Services server through a firewall? If so, you probably needed to choose an alternative security configuration. By default, Analysis

(Ruben Heetebrij) As the Web and its development mature, more systems and applications release their own Web interfaces. If, for instance, you buy a wireless access point, it can be configured through a Web page. Or, consider Internet Information Server, which has its own local Website next to the s

(Drew Georgopulos) Part I of this two-part series exploring DTS tasks illustrated how to chain different types of tasks together to collect the information you need to process data contained in a file location table. It’s a technique I used during a SQL Server project in which I built a solution tha