January 31, 2014 at 9:24 am
Hi all,
Will be taking over some systems that use these, and wondered if there are any best practice checklists to rewriting these, preferably in '08 version.
Cheers,
Jake
January 31, 2014 at 9:44 am
Research, analysis, testing.
There is no "easy" way to do this and each one requires a unique process to remove it. They just have to be dealt with one at a time.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 31, 2014 at 1:49 pm
Agreed. There's just too many variables. Example: I personally only usually use views to consolidate a standard approach to get a particular component of data in an optimal way.
IE: I need everyone with Medicare payments in the last 30 days.
If there's a few dozen views that lean on that single point of logic organization, do you really want to un-nest them?
You have to approach them like any other piece of code. Individually research the effects of removing the nesting and look for code re-usage possibilities that are being leveraged that you're about to destroy and up your maintenance.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply