Welcome to MSDN Blogs Sign in | Join | Help

November 2006 - Posts

Wednesday, November 22, 2006 11:19 AM

Query Execution Timeouts in SQL Server (Part 2 of 2)

Checklist for time out errors Memory pressure : In most cases timeouts are caused by insufficient memory (i.e. memory pressure). There are different types of memory pressures and it is very important to identify the root cause. The following articles
Posted by queryproc | 2 Comments
Monday, November 20, 2006 1:19 PM

Index Build strategy in SQL Server - Part 1: offline, serial, no partitioning

Builder (write data to the in-build index) | Sort (order by index key) | Scan (read data from source) In order to build the b-tree for the index we have to first sort the data from source. The flow is to scan the source, sort it (if possible - in memory*),
Posted by queryproc | 1 Comments
Filed under:
Tuesday, November 14, 2006 1:51 PM

Query Execution Timeouts in SQL Server (Part 1 of 2)

This short article provides a checklist for query execution time out errors in Yukon . It does not touch the time out issues on optimization and connection. Before reading this article, you are recommended to read the following post to get familiar with
Posted by queryproc | 1 Comments
Filed under:
Sunday, November 12, 2006 6:32 PM

Using ETW for SQL Server 2005

ETW stands for “Event Tracing for Windows” and it is used by many Windows applications to provide debug trace functionality. This “wide” availability is a key point of using ETW because it can help to track certain activities from end to end. For example,
Posted by queryproc | 3 Comments
Filed under: , ,
Thursday, November 09, 2006 4:05 PM

Index Build strategy in SQL Server - Introduction (II)

- Building Partitioned Index vs. Building non-Partitioned Index: The data of partitioned tables and indexes is divided into units that can be spread across more than one filegroup in a database. The data is partitioned horizontally, so that groups of
Posted by queryproc | 1 Comments
Filed under:
Wednesday, November 08, 2006 3:05 PM

Index Build strategy in SQL Server - Introduction (I)

Index Build strategy in SQL Server may vary depending on users needs. Each of these Index Build strategies may have different memory and disc space requirement. These different strategies will be discussed in the next several posts. For the beginning
Posted by queryproc | 1 Comments
Filed under:
 
Page view tracker