SQL Server knowledge center
everything about SQL Server
See also:
Other Geeks@INDC
Sign in
|
Join
|
Help
Home
Contact
About
RSS
Atom
Comments RSS
Search
Recent Posts
Fitur T-SQL Window Function Terbaru dari SQL Denali
Bermain-main dengan Fitur T-SQL Denali : SEQUENCE
Renungan atas artikel "Being a SQL Server Pro Is Hard Work!"
Found Error When Starting First SQL Denali Analysis Service in Vertipaq Mode and How to Troubleshoot
Fitur-fitur yang tidak disupport di SQL Denali
Different role of IT architects
Pertanyaan Mengenai SQL Query Optimizer
Solusi dan Pemrograman Transact-SQL : Convert Comma Delimited String into Resultset with Transact-SQL
Solusi dan Pemrograman Transact-SQL : UNPIVOT Problem and Solution
Solusi dan Pemrograman Transact-SQL
Tags
ASP.NET
Business Intelligence
C Sharp
General/motivation
LINQ
Rubrik Solusi dan Teknik Pemrograman Transact SQL
SharePoint and Microsoft Office 2007 SharePoint Server
solusi
SQL Server
SQL Server Reporting Services
Windows Communication Foundation (WCF)
Windows Workflow Foundation
News
Your database is crawling like turtles? I can turn it like sport car, contact me if you need help. My email : sologuyfromrolla@gmail.com
Navigation
Home
Blogs
Videos
Curriculum
eBooks
Jobs
Forum
Downloads
Archives
September 2011 (3)
August 2011 (2)
March 2011 (3)
February 2011 (1)
January 2011 (4)
December 2010 (2)
June 2010 (4)
May 2010 (5)
March 2010 (2)
January 2010 (10)
December 2009 (11)
November 2009 (3)
August 2009 (5)
July 2009 (10)
June 2009 (1)
April 2009 (3)
March 2009 (3)
February 2009 (11)
January 2009 (7)
December 2008 (17)
November 2008 (11)
October 2008 (5)
September 2008 (8)
August 2008 (2)
July 2008 (16)
June 2008 (15)
May 2008 (16)
April 2008 (20)
March 2008 (19)
February 2008 (16)
January 2008 (21)
December 2007 (31)
November 2007 (30)
October 2007 (16)
September 2007 (4)
August 2007 (8)
April 2007 (19)
March 2007 (1)
February 2007 (1)
July 2006 (1)
May 2006 (29)
April 2006 (11)
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
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:
SQL Server
More Posts
Next page »