SQL Server Articles

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

Install Windows 2000 Cluster Services: Installing the Windows 2000 Cluster Service: Node 1

This portion of the article shows you, step-by-step, how to install the Windows 2000 Cluster Service. Not every potential option will be discussed, only the most common. This section has been divided into two web pages to make it easier to load into your web browser and read. There are many graphics, and it make […]

Install Windows 2000 Clustering Services: Establishing User Accounts and Security

Setting up the appropriate user accounts and establishing the necessary security is one of the easiest steps when creating a cluster. It is also one of the easiest to forget. What I like to do in this step is not only set up the domain service account for the cluster service, but also to set […]

Install Windows 2000 Cluster Services: Installing and Configuring Windows 2000

Once the hardware is properly selected and assembled, the next step is to install Windows 2000. For the most part, installing Windows 2000 on servers that will be clustered is the same as any Windows 2000 installation. The focus of this section of the the article focus on what is slightly different between installing Windows […]

Install Windows 2000 Cluster Services: Selecting and Preparing the Hardware

Selecting the correct hardware, and preparing it correctly, is half the battle when clustering Windows 2000. As a rule of thumb, if you have done a good job with the hardware, you should not have any difficulty installing Windows 2000 Cluster Services. In fact, it should be a non-event. But if you don’t have the […]

How to Install Windows 2000 Cluster Services

SQL Server clustering is not an easy task. It requires a good knowledge of Windows 2000, SQL Server 7.0 or SQL Server 2000, and time. Lots of it. The purpose of this article is to get you started along your way to SQL Server clustering. As a precursor to this step, you must first install […]

Getting The Best From The SQL Server Index Tuning Wizard

The Index Tuning Wizard is a handy tool shipped as part of the SQL Server 7.0 and SQL Server 2000 Profiler that can analyze a set of SQL queries and suggest index changes that could improve their performance. Here, I will take a look at how to get the best results out of using the […]

The Importance of E-Commerce, DSS and OLTP Database End-User Service Level Analysis

This is an interesting article from the president of SQL Power Tools, which produces tools for SQL Server (and other databases) that can be used to measure database end-user service levels. If you don’t know what an end-user database service level is, then you need to read this article. Before reading this article, I was […]

Using XML To Supercharge Website Performance

With the advent of XML, we have the ability to supercharge our websites with huge performance increases. XML allows us to separate code, content, and presentation. Web developers now have three separate files which in turn will create the HTML that we output. Since the content is in a distinct file separate from the code […]

SQL Server Full Text Search Optimization

Full text indexing is a great feature that solves a long running database problem, the searching of textual data columns for specific words and phrases in SQL Server databases. However, as the full-text search engine is a separate component of SQL Server (it uses the Microsoft Search Service) this can be a potential performance problem […]

Use OPENXML to Minimize SQL Server Database Calls

OPENXML is a new function added to SQL Server 2000 that provides a rowset view over an XML document. Since a rowset is simply a set of rows that contain columns of data, OPENXML is the function that allows an XML document to be treated in the familiar relational database format. It allows for the […]