SQL Server Articles


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

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 […]

Installation of SQL Server Clustering

Pre-Installation Spot Verification Review the Windows Event Log, it should not have any errors before you begin the SQL Server clustering installation. Ping from one node to another to verify a good connection and a latency of less than 500ms. In regard to the services listed under Pre-Install Preparation Checklist above, make sure all of […]

Un-Install a SQL Server Cluster: Step-by-Step

If SQL Server Cluster Install ends up in errors and fails, consider doing a clean up of the cluster install and then re-start it. Here is a step-by-step process which gives a clean un-install of a SQL Server Cluster environment. Step-1 Execute sqlrem.bat Execute sqlrem.bat with following parameters on each node: Syntax: sqlrem.bat <sql install […]

What is New with SQL Server Clustering on Windows 2003

Security Patch – Server Accessibility If latest security patches are not installed on SQL Server, you may see following error message in event log. You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the […]

Basics of SQL Server Clustering

If your AAA critical SQL server faces a memory board failure, how long will be the outage? How much will this cost your business in productivity and data availability to the users? Being a SQL Server DBA can be demanding and stressful, as the success of your application is often a function of your database […]
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 |