We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
But the short answer is likely that none of the tables are properly normalized. That sounds bad, but it's almost certainly true. Typically tables are created by developers who give zero thought to normalization.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
Ok, a few queries and the SSMS graphical tool can help identify candidates for normalization. But, I now worry that a single normalization could break countless store procedures, since they create and query the non-normalized data.
I have used SQL Server automation tools which could certainly help in this situation.
For example, Red Hat has a tool I once used to identify all uses of a certain variable name, which saved huge amounts of time, since it looked through all database objects.
Any suggestions on whether SSMS does this, or what tools to consider?
Unlimited question asking, solutions, articles and more.
curiouswebster
ASKER
Wow! You mean I can change the underlying schema to be more normalized, then use Views to handle legacy queries from both the source code and the Analysts, who interact with the database throughout the day?
If this is true, is there any benefit to normalization?
Don't get me wrong, organizationally, this may be a life-saver. Then, as time permits, we upgrade code and Analyst queries to the new schema.
In fact, we are considering giving the Analysts their own database schema.
How would a dedicated Analyst schema help or hurt this effort?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
But the short answer is likely that none of the tables are properly normalized. That sounds bad, but it's almost certainly true. Typically tables are created by developers who give zero thought to normalization.