SQL Server Articles


Categories : Performance | Audit | Business Intelligence | Clustering | Developer | Reporting | Windows Server | SQL Azure | Powershell | ASP.NET | Other .NET

SQL Server Replication Across Domains and the Internet

Replication over the Internet or across non-trusted domains is usually performed using a virtual private network (VPN), and consequently the configuration is much the same as that used on a LAN. This article outlines what to do if such a VPN is not available. While it’s true that in almost all cases you wouldn’t consider […]

Transferring SQL Server Statistics From One Database to Another

Many production databases today are in the tens or hundreds of gigabytes in size. That size is not a problem for production hardware. However, developers generally like to work on their personal computers, including notebooks with limited disk capacity, so a 10-100GB database size is an issue. Furthermore, it can be impractical to transfer such […]

SQL Server 2005: The Replication GUI

This article describes the changes to replication from the point of view of the SQL Server 2005 GUI. In case you haven’t already been checking out the new version, ‘Microsoft SQL Server Management Studio’ is the new graphical replacement for ‘Enterprise Manager’. It’s probably true to say that unlike many other administrative tasks, most DBAs […]

SQL Server Parallel Execution Plans

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 various Microsoft documents describe the principles of parallel execution […]

Processor Performance, Update 2004

This article is a follow on to the original processor performance article I wrote, with analysis of processor performance results released in the last year. The original article explains many of details discussed here. Of the new material presented here: First, the range of results published for the TPC-C benchmark now allows meaningful analysis. Second, […]

A First Look at Execution Plan Costs in Yukon Beta 1

Many of us are interested in the features and changes in Yukon. A quick look shows some changes in the execution plan cost formulas for Yukon Beta 1. It is quite likely that more changes will be made between beta 1 and the final release. Most of the cost formulas appear not to have changed. […]

Advanced SQL Server Locking

I thought I knew SQL Server pretty well. I’ve been using the product for more than 6 years now, and I like to know my tools from the inside out. While teaching a SQL Server programming course, I noticed that the Microsoft material presented a lock compatibility table. The same table is presented at MSDN. […]

How to Attain SQL Server High Availability at Minimal Cost

You may find it hard to believe, but it is possible to maintain SQL Server high availability and not spend a fortune. In fact, you can spend a fortune and still not get SQL Server high availability. Sound like a paradox? Not really. SQL Server high availability is not a direct function of how much […]

An Introduction to Clustered and Non-Clustered Index Data Structures

When I first started using SQL Server as a novice, I was initially confused as to the differences between clustered and non-clustered indexes. As a developer, and new DBA, I took it upon myself to learn everything I could about these index types, and when they should be used. This article is a result of […]

Designing your SQL Server Cluster

Preparing Cluster Resource Groups As a first step, the DBA should list all server-based applications and services that will run within the cluster environment, regardless of whether they will need high availability. Applications and services that need to be highly available should be placed into resource groups. Other applications should be tracked, and their interactions […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |