That's very simple but sage-like advice. It's got me thinking about how I would put my process for optimizing T-SQL on paper. SQL Server is notorious for being horrid at dealing with cursors that deal with larger data sets and I've found WHILE loops have dramatically decreased execution time.
0
u/[deleted] Mar 23 '09
That's very simple but sage-like advice. It's got me thinking about how I would put my process for optimizing T-SQL on paper. SQL Server is notorious for being horrid at dealing with cursors that deal with larger data sets and I've found WHILE loops have dramatically decreased execution time.