Tell different tricks and fusible ways ?
Tally Table, Pseudo-Cursors, "Set-based" thinking, SARGable queries, "Divide'n'Conquer" techniques, Windowing Functions, Cascading CTEs and Cross Apply's, deep understanding of B-Tree indexing, Inline Table Valued Functions, correct interpretation of Execution Plans, ability to make millions of rows of test data in just a couple of seconds, knowing what the limits of a return should be, and in-depth knowledge of T-SQL syntax (especially for all built in functions) and object types, a tremendously open mind, a huge amount of patience, and lots and lots of practice.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs