StrCat.Catter - An Efficient String Concatenation Component
This is a technical article aimed toward ASP/SQL developers who are looking to help speed the concatenation of strings, such as SQL query strings. I wrote the COM component - StrCat.Catter - because string concatenation in VBscript has poor performance characteristics.
Read the Article
|
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 exceptions, but let's not go there.
Read the Article
|
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, Excel, and of course, SQL Server.
Read the Article
|
How to Do SQL Server Performance Trend Analysis -- Part 2: Importing Log Data into 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 the Article
|
How to Do SQL Server Performance Trend Analysis -- Part 3: Trend Analysis Using Microsoft Excel
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 the Article
|
How to Do SQL Server Performance Trend Analysis -- Part 4: Interpreting Performance Counters
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 perform trend analysis on it. Now it is time to take a look at how to interpret the data you have collected.
Read the Article
|
How to Do SQL Server Log Shipping
In a perfect world we wouldn't need standby servers for our SQL Servers. Our hardware would never fail, NT Server 4.0 or Windows 2000 would never blue screen, SQL Server would never stop running, and our applications would never balk.
Read the Article
|
Implementing SQL Server in an OLTP Environment
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.
Read the Article
|
Introduction to SQL Server Performance Tuning
I wish I was able to provide you with a comprehensive list of steps that you could follow that would optimize your SQL Server for performance 100%. Unfortunately, life is not so easy. SQL Server performance is a complex interchange among many variables, many of which you have little or no control.
Read the Article
|
SQL Server 2000 Performance Tuning Tools
The SQL Server 2000 Query Analyzer is not only a great tool for developing and debugging Transact-SQL code, it is also a great tool for performance tuning Transact-SQL code. In this section we will take a look at what the Query Analyzer can do, and also learn a little about how it can be used to help identify and resolve performance problems. And like many of the more advanced SQL Server 2000 tools, you need to have a fairly good understanding of Transact-SQL to get the most out of this tool. Let's take a look at some of the key features included with Query Analyzer that can be used to help performance tune Transact-SQL code.
Read the Article
|
