July 2008 - Posts

1
Comments

Execution Plan Optimality through Statistics Information by Kasim.Wirama

Execution Plan Optimality through Statistics Information By : Kasim Wirama, MCDBA As we know that index is used for fast query response time. What causes index could speed up fast query response time? It is because index helps optimizer to generate good...
Filed under:
0
Comments

Welcome to SQL Server Knowledge Centre by Kasim.Wirama

Welcome to SQL Server Knowledge Centre I name my blog as knowledge source for SQL Server, hopefully someday it will become SQL Server knowledge portal, not just portal. So, I welcome you guys to visit SQL SERVER KNOWLEDGE CENTRE . Share this post: | ...
Filed under:
15
Comments

Common Mistakes in SQL Practice by Kasim.Wirama

Common Mistakes in SQL Practice By : Kasim Wirama, MCDBA Some common mistakes are always found in all projects when I have ever involved. Here are points I would like to share with you. Data file and transaction log file put in same drive. For development...
Filed under:
0
Comments

Tips to Detect Suboptimal Execution Plan by Kasim.Wirama

Tips to Detect Suboptimal Execution Plan By : Kasim Wirama, MCDBA This posting, I would like to give important points that need to consider when reviewing an execution plan. With this information on this posting, you can assess whether your execution...
Filed under:
6
Comments

Examine Database Backup Size by Kasim.Wirama

Examine Database Backup Size By : Kasim Wirama, MCDBA I have seen Idera products several times intended for SQL Server use through several advertisements at SQL Server Magazine. One of its products is SQLSafe which has backup and restore functionality...
Filed under:
1
Comments

Dealing with Cardinality Estimation Issue by Kasim.Wirama

Dealing with Cardinality Estimation Issue By : Kasim Wirama, MCDBA This posting, I would discuss about cardinality estimation issue that leads to suboptimal execution plan in SQL Server. It applies to all SQL Server versions. Generally, SQL Server always...
Filed under:
0
Comments

2 Stored Procedures for generating index information by Kasim.Wirama

2 Stored Procedures for generating index information By : Kasim Wirama, MCDBA To enhance performance of slow running queries, usually a DBA implements index. When a database consists of hundreds of tables, job for maintaining indexes doesn’t seem easy...
Filed under:
0
Comments

Bitmap Operator by Kasim.Wirama

Bitmap Operator By : Kasim Wirama, MCDBA This posting, I would like to dissect other operator that might show up in query execution plan of SQL Server, i.e. bitmap filtering. As the name implies, bitmap filtering will use bitmap as the way to mark rows...
Filed under:
0
Comments

Parallelism in Hash Join by Kasim.Wirama

Parallelism in Hash Join By : Kasim Wirama, MCDBA In this posting, I would talk about parallelism in hash join. If you would like to know algorithm in hash join, you can refer to my past posting titled Nested Loop, Merge Join, and Hash Join Algorithm...
Filed under:
0
Comments

Parallelism in Merge Loop by Kasim.Wirama

Parallelism in Merge Loop By : Kasim Wirama, MCDBA This posting, I would discuss about parallelism in merge loop operator and its impact to performance. Parallelism involves two or more threads. And in merge join for single thread, the algorithm works...
Filed under:
2
Comments

Merging, Non-Merging Parallelism by Kasim.Wirama

Merging, Non-Merging Parallelism By : Kasim Wirama, MCDBA This posting, I delve deeper into parallelism operator in execution plan. Parallelism is knows as exchange operator. It is named as exchange operator because producer threads distribute rows into...
Filed under:
1
Comments

Broadcast Algorithm in Distribute Stream Parallelism of SQL Server Execution Plan by Kasim.Wirama

Broadcast Algorithm in Distribute Stream Parallelism of SQL Server Execution Plan By : Kasim Wirama, MCDBA I have shown you round robin implementation in distribute stream. From performance perspective, round robin is less desirable type of parallelism...
Filed under:
1
Comments

Round Robin Algorithm in Distribute Stream Parallelism of SQL Server Execution Plan by Kasim.Wirama

Round Robin Algorithm in Distribute Stream Parallelism of SQL Server Execution Plan By : Kasim Wirama, MCDBA I would like to show round robin implementation in distribute stream parallelism. Before I talk about round robin specific in distribute stream...
Filed under:
1
Comments

Error Log Management by Kasim.Wirama

Error Log Management By : Kasim Wirama, MCDBA This posting, I would like to share some information that might be useful for administering error log in SQL Server 2005 and 2008. Error log filename is ERRORLOG (without file extension, but it can be opened...
Filed under:
4
Comments

Parallelism in Nested Loop by Kasim.Wirama

Parallelism in Nested Loop By : Kasim Wirama, MCDBA This posting, I would show behavior characteristic of parallelism in nested loop join. Let’s build these 2 big tables first, with the following TSQL script : CREATE TABLE bigtable ( col1 INT PRIMARY...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems