SQL Server 2005 Index Best Practices

In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.

BCP Format File Builder

Utility stored procedure to create non-xml format file for BCP/BULK INSERT processes. Very useful for text-qualified CSV files.

The Client Executable

SQL Server 2005

Service Pack 2 Uninstall Not Possible for SQL Server 2005

You probably already know that SQL Server 2005 SP2 has been released. This is a good thing if you are in need of one of the changes that are included in this service pack. In a previous tip, SQL Server 2005 - Service Pack 2, we took a look at what was to be included in this second service pack for SQL Server 2005. The question that you often face is should I install this service pack. One thing to note before you install SP2 is that there is no way to uninstall it once it is installed.

Failing SQL 2005 Cluster Installation because of too many cpu's

A Failing cluster installation because of too many processors. Sander Stad explains how you might be able to solve this in your environment.

Get DDL for any SQL 2005 table

returns CREATE TABLE script for any table. including schema name,calculated columns,
indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything.

Basic Server Reporting Functionality in SQL Server 2005 Express Edition

In the recent installments of our series dedicated to the most prominent features of SQL Server 2005 Express Edition, we have started an overview of its reporting capabilities. This article focuses on elementary methods you can employ to generate custom reports.

A Technical Comparison of Replication and Remote Data Access Features in SQL Server 2005 Mobile Edition 3.0

Compare feature sets for the two Microsoft SQL Server 2005 Mobile Edition 3.0 (SQL Server Mobile) connectivity solutions, merge replication and remote data access (RDA), and understand which connectivity solution might be more beneficial for your project.

Enhancing the readability of your code: Table aliasing in sql

When writing SQL, picking good tables aliases can greatly enhance the readability of your code