Dear Geeks,

Last Staurday, 18th July while interacting with attendees of SQL Server Day event held at Gurgaon and feedback from my friend Prince, I realized that I should publish a revised index of my series One Operator a day.

I published TOC for the same sometime back as per the advice of MSDN moderator Ronen but my readers wanted something different and this blog post is an outcome of our discussion on the event. Straight to the subject, here is what you wanted friends;

SQL Server Scan Operator(s)

http://www.sqlservergeeks.com/sql-server-table-scan-operator/

http://www.sqlservergeeks.com/sql-server-clustered-index-scan-operator/

SQL Server Index Seek Operator(s) and comparison

http://www.sqlservergeeks.com/sql-server-clustered-index-seek-operator/

http://www.sqlservergeeks.com/sql-server-index-seek-nonclustered/

http://www.sqlservergeeks.com/sql-server-clustered-index-scan-vs-clustered-index-seek/

SQL Server Key Lookup Operator

http://www.sqlservergeeks.com/sql-server-key-lookup-operator-part-1/

http://www.sqlservergeeks.com/sql-server-key-lookup-operator-part-2/

http://www.sqlservergeeks.com/sql-server-key-lookup-operator-part-3/

http://www.sqlservergeeks.com/sql-server-key-lookup-operator-part-4/

http://www.sqlservergeeks.com/sql-server-rid-lookup-operator/

SQL Server Sort Operator

http://www.sqlservergeeks.com/sql-server-sort-operator-part1/

http://www.sqlservergeeks.com/sql-server-sort-operator-part2/

SQL Server aggregate operator

http://www.sqlservergeeks.com/sql-server-aggregate-operator-stream-aggregate-part1/

http://www.sqlservergeeks.com/sql-server-aggregate-operator-stream-aggregate-part2/

http://www.sqlservergeeks.com/sql-server-aggregate-operator-stream-aggregate-part3/

SQL Server Compute Scalar Operator

http://www.sqlservergeeks.com/sql-server-compute-scalar-operator-part1/

http://www.sqlservergeeks.com/sql-server-compute-scalar-operator-part2/

SQL Server Concatenation Operator

http://www.sqlservergeeks.com/sql-server-concatenation-operator-part1/

http://www.sqlservergeeks.com/sql-server-concatenation-operator-part2/

http://www.sqlservergeeks.com/sql-server-concatenation-operator-part3/

SQL Server Assert operator

http://www.sqlservergeeks.com/assert-operator-sql-server-part1/

http://www.sqlservergeeks.com/assert-operator-sql-server-part2/

http://www.sqlservergeeks.com/assert-operator-sql-server-part3/

SQL Server Hash Match join/aggregate operator

http://www.sqlservergeeks.com/sql-server-hash-match-join-operator/

http://www.sqlservergeeks.com/sql-server-hash-match-aggregate-operator-part1/

http://www.sqlservergeeks.com/sql-server-hash-match-aggregate-operator-part2/

http://www.sqlservergeeks.com/sql-server-hash-match-aggregate-operator-part3/

SQL Server Nested Loop Join Operator

http://www.sqlservergeeks.com/sql-server-nested-loop-join-operator-part1/

http://www.sqlservergeeks.com/sql-server-nested-loop-join-operator-part2/

SQL Server Merge Join Operator

http://www.sqlservergeeks.com/sql-server-merge-join-operator-part1/

http://www.sqlservergeeks.com/sql-server-merge-join-operator-part2/

SQL Server Segment Operator

http://www.sqlservergeeks.com/sql-server-segment-operator/

SQL Server Table Spool Operator

http://www.sqlservergeeks.com/sql-server-table-spool-operator-lazy-spool-part1/

http://www.sqlservergeeks.com/sql-server-table-spool-operator-lazy-spool-part2/

http://www.sqlservergeeks.com/sql-server-table-spool-operator-lazy-spool-part3/

Merge Interval Operator

http://www.sqlservergeeks.com/merge-interval-operator-part1/

http://www.sqlservergeeks.com/merge-interval-operator-part2/

SQL Server execution plan Filter Operator

http://www.sqlservergeeks.com/sql-server-execution-plan-filter-operator/

Online Index Insert Operator

http://www.sqlservergeeks.com/online-index-insert-operator/

Sequence Project Operator

http://www.sqlservergeeks.com/sequence-project-operator/

SQL Server Eager Spool operator

http://www.sqlservergeeks.com/sql-server-eager-spool-operator-part1/

http://www.sqlservergeeks.com/sql-server-eager-spool-operator-part2/

SQL Server Cursor Operators

http://www.sqlservergeeks.com/sql-server-cursor-operators-part1/

http://www.sqlservergeeks.com/sql-server-cursor-operators-part2

http://www.sqlservergeeks.com/sql-server-cursor-operators-part3

http://www.sqlservergeeks.com/sql-server-cursor-operators-part4

http://www.sqlservergeeks.com/sql-server-cursor-operators-part5

http://www.sqlservergeeks.com/sql-server-cursor-operators-part6

http://www.sqlservergeeks.com/sql-server-cursor-operators-part7

http://www.sqlservergeeks.com/sql-server-cursor-operators-part8/

SQL Server Nested Loop Join Operator – Revisiting

http://www.sqlservergeeks.com/sql-server-nested-loop-join-operator-revisiting-part1

http://www.sqlservergeeks.com/sql-server-nested-loop-join-operator-revisiting-part2

SQL Server Parallelism Operator

http://www.sqlservergeeks.com/sql-server-parallelism-operator

SQL Server Join/table/query hints execution plan

http://www.sqlservergeeks.com/sql-server-join-hints-execution-plan/

http://www.sqlservergeeks.com/sql-server-table-hints-execution-plan

http://www.sqlservergeeks.com/sql-server-query-hints-execution-plan-part1

http://www.sqlservergeeks.com/sql-server-query-hints-execution-plan-part2

http://www.sqlservergeeks.com/sql-server-query-hints-execution-plan-part3

SQL Server expand views hint and execution plan

http://www.sqlservergeeks.com/sql-server-expand-views-hint-execution-plan

SQL Server plan guide and execution plan

http://www.sqlservergeeks.com/sql-server-plan-guide-and-execution-plan

OPTIMIZE FOR query hint in SQL Server

http://www.sqlservergeeks.com/optimize-query-hint-sql-server/

I hope this helps, and do not forget to register for Asia’s first SQL Conference.

Regards,

Kanchan

 

Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook | Follow me on Twitter | Follow me on FaceBook