DBCC SHOWCONTIG Improvements in SQL Server 2005 and comparisons to SQL
This document describes the problem and the workaround in SQL Server 2000, and the solution and recommendation in SQL Server 2005.
2006-12-08
2,616 reads
Performance Tuning
Using SQL Server 2005 Profiler
In this presentation, Brian introduces SQL Server 2005 Profiler. He shows you to integrate System Monitor logs (also called perfmon) to find what queries were running against your machine during key performance failures. He also shows you how to output the query plan into an XML file.
2006-12-04
2,253 reads
TEMPDB Capacity Planning and Concurrency Considerations for Index Crea
Some of the key factors to consider while you devise an index maintenance plan are performance, concurrency, and required resources. SQL Server 2005 provides you with several options for index create and rebuild operations that you can use to effectively meet the requirements of performance, concurrency, and resources.
2006-12-01
2,142 reads
Basics of Statistics in SQL Server 2005
If you're having a problem with particular queries, there are a few things you can do with the information that the server collects about the distribution of data in columns and indexes.
2006-11-30
3,327 reads
SQL Server 2005 Waits and Queues
The methodology helps identify the areas of slow performance by looking at the problem from two directions called Waits and Queues. An analysis of Waits indicates where SQL Server is spending lots of time waiting. In addition, the biggest waits point out the most important or relevant Queues (that is, Performance Monitor counters and other data) for this workload.
2006-11-24
2,377 reads
Gathering Metrics with SMO
Keeping track of the performance of your SQL Servers requires metrics. There are many methods for doing this, but some type of automated process is essential these days with DBAs managing many servers. New author Allen White brings us a technique for doing this using SMO, the replacement for DMO in SQL Server 2005.
2006-11-22
6,003 reads
Table Variables
New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.
2006-11-21
17,006 reads
Analysis of SQL Server Performance Data
Gathering performance data on your servers can be a cumbersome task without paying for an expensive tool. New author Jambu Krishnamurthy brings us a short tutorial on how you can gather this data from Perfmon and import it into SQL Server for reporting.
2006-10-30
11,383 reads
Fine Tuning your Database Design in SQL 2005
If your SQL Server app is suffering from poor performance and you suspect a missing index, then read on
2006-10-30
2,990 reads
Indexes and Fragmentation in SQL Server 2000 Part 1
How do your indexes perform under different fragmentation levels in SQL 2000? Joe Doherty brings us part 1 of his look at this topic with an examination of how your data is stored and a detailed analysis of DBCC SHOWCONTIG.
2006-10-23
18,191 reads
Blogs
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers