I need to create a new application on a new database which has around 7000 tables. This database is huge only from a table/column/join perspective, but not from a row/size perspective. What best practice would you recommend from a design perspective?
I am thinking that I will create a single qvw, but I am concerned that it will soon become unwieldy.
