SQL Server Articles

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

SQL Server Performance: Query Tuning vs. Process Tuning

In the different projects where I perform a performance audit or am involved in performance tuning, I often find that while queries and stored procedures function correctly, they are not efficient in processing larger data sets. Many OLTP databases are set up as OLAP databases to handle single records instead of a record set as […]

Winning T-SQL Games from the Red Gate Software-Sponsored January 2006 Contest

This past January, Red Gate Software sponsored a T-SQL contest. The goal was to write a game in T-SQL that was fun to play. Below are the links to the three games that won. When you click on a link, you will be brought to a new page with the T-SQL code you need to […]

Scripts for Space Monitoring Report

The SQL to enter in the “Execute SQL Task” if not exists(select * from master..sysdatabases where name=’dbamaint’) create database dbamaint go alter database dbamaint set RECOVERY SIMPLE go use dbamaint go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_filespacestats]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1) drop procedure [dbo].[sp_filespacestats] GO SET QUOTED_IDENTIFIER ON GO SET […]

Monitor Your Database Servers with DTS, Part 3: Space Monitoring of SQL Servers

In the previous two articles in this series on monitoring a large number of servers from a centralized location using Data Transformation Services (DTS) (see Part 1 and Part 2), I explained how to set up a report to ensure that backups are happening as per the backup policy and how to monitor SQL Server […]

Boost Performance and Reduce Code Use With SQL Server Aggregate Functions

Aggregate functions, a staple means of summarizing large volumes of data for serious database developers, are mainly used for generating business data reports. Aggregate functions allow you to retrieve summarized information from a table by operating on a set of data as a whole rather than on each data element. These functions contribute to keeping […]

Get an Edge with SQL Server 2005 Reporting Services

The ultimate utility of a database lies in presenting the data in different formats to fulfill the information requirements of various users. Microsoft SQL Server 2005 Reporting Services (SSRS) gives nontechnical end users and programmers a server-based reporting platform that will generate any kind of report from any kind of data source for both desktop […]

How to Perform a SQL Server Performance Audit

If you have been a DBA for long, then you will know that performance tuning SQL Server is not an exact science. And even if it were, it would still be difficult to find the “optimal” configuration for the “optimal” performance. This is because there are few absolutes when it comes to performance tuning. For […]

Clustered Indexes in SQL Server: Things You Need to Know

This article covers a few, more advanced topics about the usage of clustered indexes in SQL Server. Not only will I try to convince you of the absolute necessity of using clustered indexes, I’ll also give you some tips on how to use them in a not so obvious context. Why You Need Clustered Indexes! […]

How to Set Up a SQL Server Stress Test Environment in 8 Steps: Lessons From the Field

This article is the third in a series of four where I share my findings on baselining, monitoring, stress testing and performance tuning. It builds on the foundations of my previous articles on baselining and monitoring. Having a monitoring system in place is an important step in making you feel comfortable with what goes on […]

Using Master..Sysprocesses to Isolate Performance Issues – Part 1

It’s 4:30 P.M. on Friday and your boss comes to you in a panic. The e-commerce system is down, and the database is to blame. You go through your usual what’s-going-on checklist and all you can tell is the CPU on the SQL Server is pegged at 100 percent. You check Profiler, but no high […]