May 2008 - Posts

2
Comments

Study of Stream Aggregation by Kasim.Wirama

Study of Stream Aggregation By : Kasim Wirama, MCDBA Last article, I talk about scalar aggregation and also I gave example of scalar and stream aggregation. On last article, I also give possible execution plan for scalar aggregation. This article, I examine...
Filed under:
0
Comments

More about Merge Join by Kasim.Wirama

More about Merge Join By : Kasim Wirama, MCDBA I would like to tell you further about merge join operator in execution plan. There are some categorizations for merge loop, based on sorting and relationship between 2 input set. And I would describe what...
Filed under:
0
Comments

Performance Study of Scalar Aggregation by Kasim.Wirama

Performance Study of Scalar Aggregation By : Kasim Wirama, MCDBA You might use aggregate function in SQL Server such as COUNT, MIN, MAX, AVG, SUM and DISTINCT. Let’s look into these aggregate functions, and its execution plan. There is scalar aggregation...
Filed under:
0
Comments

Quote of the day by Kasim.Wirama

Quote of the day Query statement doesn't guarantee result in sorted order. Share this post: | | | |
Filed under:
0
Comments

Nested Loop on Partitioned Table/Index by Kasim.Wirama

Nested Loop on Partitioned Table/Index By : Kasim Wirama, MCDBA This article I would like to show you the behavior of nested loop in partitioned table/index in SQL Server 2005. Partitioning has been introduced since SQL Server 2005. This feature will...
Filed under:
0
Comments

Query Plan for Nested Loop by Kasim.Wirama

Query Plan for Nested Loop By : Kasim Wirama, MCDBA This article, I would like to show possible query plan for nested loop and also which types of query plan for nested loop is considered in optimization form. Let’s take a look for this physical join...
Filed under:
1
Comments

Performance characteristics of Nested Loop, Merge Join and Hash Join by Kasim.Wirama

Performance characteristics of Nested Loop, Merge Join and Hash Join By : Kasim Wirama, MCDBA Nested loop, merge join and hash join is common operators which you will find out in execution plan as long as your query contains any logical joins (inner join...
Filed under:
0
Comments

Nested Loop, Merge Join, and Hash Join algorithm by Kasim.Wirama

Nested Loop, Merge Join, and Hash Join algorithm By : Kasim Wirama, MCDBA If you observe execution plan on your query using join types, you will find out the following operators: nested loop, merge loop and hash join. I would like to describe algorithm...
Filed under:
0
Comments

Types of Join by Kasim.Wirama

Types of Join By : Kasim Wirama, MCDBA In this article, I would like to introduce types of join in SQL Server. I give examples inner join, cross join, left outer join, full outer join and left semi join and left anti semi join. Before I progress to each...
Filed under:
7
Comments

SQL Quiz by Kasim.Wirama

SQL Quiz Saya hendak memberikan 1 jatah berlangganan technet gratis selama setahun kepada peserta milis melalui quiz SQL ini dengan menampilkan 5 long running query lewat DMV, kolom-kolom yang perlu ditampilkan adalah waktu eksekusi maksimum, waktu eksekusi...
Filed under:
1
Comments

Debugging Occasionally Error with SQL Trace by Kasim.Wirama

Debugging Occasionally Error with SQL Trace By : Kasim Wirama, MCDBA You have created a stored procedure and you tested your stored procedure works fine in testing environment. After deployment, your stored procedure sometimes doesn’t work as expected...
Filed under:
0
Comments

Useful Events in Profiler by Kasim.Wirama

Useful Events in Profiler By : Kasim Wirama , MCDBA Profiler is excellent tool provided to monitor SQL Server performance and troubleshoot SQL Server database objects. If you open profiler, you will be presented with many events, you don’t have the use...
Filed under:
0
Comments

Query Processor Engine in SQL Server by Kasim.Wirama

Query Processor Engine in SQL Server By : Kasim Wirama, MCDBA Are you interested with SQL Server engine internal? If yes, I would like to show you what you should know about what query processor engine is and how it works. Query processor engine is one...
Filed under:
0
Comments

A Lesson about Index Ordering by Kasim.Wirama

A Lesson about Index Ordering By : Kasim Wirama , MCDBA I have posted articles about index in SQL Server 2005. They are important to be understood the way they access qualified records, but there are other aspect you need to consider, it is index ordering...
Filed under:
11
Comments

Query dari 23 jam ke 7 detik lalu ke 2 detik; Ketawa ngakak by Kasim.Wirama

Query dari 23 jam ke 7 detik lalu ke 2 detik; Ketawa ngakak By : Kasim Wirama, MCDBA Saya coba ceritakan sedikit mengenai pengalaman tuning. sebulan lalu saya ditelpon dari salah satu karyawan sebuah perusahaan di Sydney. Sepertinya dia sering baca ke...
Filed under:
More Posts Next page »
Copyright © INDC, 2006. All rights reserved.
Powered by Community Server (Commercial Edition), by Telligent Systems