SQL Server Performance Tuning

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

Avoiding Bottlenecks with Temporary Tables

Overview Were you aware that the act of populating a SQL Server temporary table can cause system-wide performance bottlenecks on your server? Problems can occur both with SQL Server 6.5 and 7.0 in different ways, and in this article I will discuss how best to avoid them. Bottlenecks in SQL Server 6.5 Many people use […]

StrCat.Catter – An Efficient String Concatenation Component

I wrote the COM component – StrCat.Catter – because string concatenation in VBscript has poor performance characteristics. I found that code like this:<%Dim rsSet rs = ExecuteSql(“SELECT Username FROM Users ORDER BY Username”)Dim some_strsome_str = “”do until rs.EOFsome_str = some_str & rs(0) & “<br>” & vbCrLfrs.MoveNextloopResponse.Write some_str%>performed very poorly. The code took a long time […]

SQL Server Lock Contention Tamed: The Joys Of NOLOCK and ROWLOCK

Relational databases, like Microsoft’s SQL Server, use locks to prevent multiple users from making conflicting modifications to a set of data. When a set of data is locked by a user, no other users can modify that same set of data until the first user finishes modifying the data and relinquishes the lock. There are […]

How to Do SQL Server Performance Trend Analysis Part 1: Using Performance Monitor to Log Data

In this four-part tutorial, you will learn how to use NT Server 4.0′s Performance Monitor and Microsoft Excel to monitor and analyze SQL Server performance. You will also learn how to use a SQL Server database to store your Performance Monitor logs. This tutorial assumes that you already know the basics of using Performance Monitor, […]

How to Do SQL Server Performance Trend Analysis Part 2: Storing Performance Data in SQL Server

This is part two of a four-part tutorial. This part discusses how to use SQL Server to store Performance Monitor log data. Part three will show you how to use Microsoft Excel to analyze the Performance Monitor Data. Part four will show you how to interpret your results. Read Part One. Read Part Three. Review […]

How to Do SQL Server Performance Trend Analysis Part 3: Storing Performance Data in SQL Server

This is part three of a four-part tutorial. This part discusses how to use Microsoft Excel to create analysis charts and how to perform trend analysis using Performance Monitor data. Part four will show you how to interpret your results. Read part one. Read part two. This article uses Microsoft Excel 97 for its examples. […]

How to Do SQL Server Performance Trend Analysis Part 4: Storing Performance Data in SQL Server

This is part four of a four-part tutorial. This part discusses how to interpret the most common NT Server and SQL Server Performance Monitor counters. Introduction In the previous three parts of this tutorial, you learned how to use Performance Monitor to collect SQL Server-related performance data, store it in SQL Server, and how to […]

Implementing SQL Server in an OLTP Environment

Introduction Business application development exists as an increasingly complex process. Information technology managers and developers working for an organization that necessitates a business application are required to evaluate and implement appropriate application modeling strategies, software, database technologies and solution models. It is often conceivable that during the application development process, technologies, methodologies and development methods […]
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 |