sqldbaonly (7/5/2013)
hi,Tell different tricks and fusible ways ?
For T-SQL...
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.
--Jeff Moden
Change is inevitable... Change for the better is not.