SQL Server Articles


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

An Introduction to SQL Server Query Tuning

During a recent interview to find a new job before my contract ran out, I was asked a question that took me by surprise. The interviewer simply asked me what steps I took to decide which stored procedures needed optimizing and what steps I used to optimize those queries. What took me by surprise was […]

SQL Server Application and Transact-SQL Performance Checklist

Return to Previous Article in the Series Performance Audit Checklist Transact-SQL Checklist Your Response Does the Transact-SQL code return more data than needed? Are cursors being used when they don’t need to be? Are UNION and UNION SELECT properly used? Is SELECT DISTINCT being used properly? Is the WHERE clause sargable? Are temp tables being […]

Strategies to Reduce SQL Server Blocking

No reasonable strategy for the resolution of SQL Server blocking problems can be found until one has determined the precise nature of the block. The most obvious criterion for distinguishing between different blocking issues is their average duration. The following categories emerge as a result of this division: Short-time Blocking: Average duration less than three […]

Sending SQL Server Notifications with CDOSYS

While SQL Server has a very mature set of tools, one thing that is lacking is the ability to send a simple email alert based on a pre-defined set of rules. At first glace, it appears that email notifications exist, but what becomes a problem to many people is the requirement for a MAPI subsystem […]

How Using the Windows 2000 Encrypted File System to Secure SQL Server Databases and Backups Affects SQL Server’s Performance

Chris is the author of the book, SQL Server for the Oracle DBA Those running Windows 2000 can take advantage of the EFS (encrypted file system) for encrypting SQL Server database and/or backup files. In some organizations, encrypting data is mandatory, and as you might expect, it can exact a performance penalty. In this article, […]

SQL Server Hardware Resource Planning

There is a growing demand for high performing, fast response applications in today’s industry. In many organizations, a SQL Server 2000 server may be dedicated for the use of one particular application. From the ground up, analyzing and determining hardware requirements best suited for individual specific applications may help these application provide the timely response […]

Implementing Triggers in SQL Server 2000

Triggers are special types of Stored Procedures that are defined to execute automatically in place of or after data modifications. They can be executed automatically on the INSERT, DELETE and UPDATE triggering actions. There are two different types of triggers in Microsoft SQL Server 2000. They are INSTEAD OF triggers and AFTER triggers. These triggers […]

How to Select Indexes for Your SQL Server Tables

Indexing is one of the most crucial elements in increasing the performance of SQL Server. A well-written query will not show its effectiveness unless powered by an appropriate index or indexes on the table(s) used in a query, especially if the tables are large. Indexes exist to make data selection faster, so the focus of […]

An Interview with the Authors of SQL Performance Tuning

Peter Gulutzan and Trudy Pelzer are the co-authors of SQL Performance Tuning, a new book on how to performance tune SQL code. In this interview, the authors tell us a little about their book and offer some advice for DBAs and SQL developers. Please tell us about yourselves. PETER GULUTZAN: I worked for a few […]

SQL Server Quantitative Performance Analysis

NOTE: See bottom of page to access all of the available articles. Abstract Quantitative models for the SQL Server internal query cost formulas and the true measured query costs for basic SQL operations are presented. The internal cost formulas are used by SQL Server’s Query Optimizer to determine the execution plan based on existing indexes […]
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 |