February 4, 2004 at 5:35 am
Hi gurus, need your help.i have been asked to undertake to db review prog for a client. I'd like to seek your help in preparing a check list for the list of things to be considered while reviewing the db.The db has been designed to generate dynamic tables of large no's. Some of the tables have around 160 columns and the size of the each row seems to be reaching some whopping figures.
Could anybody here give some precise figures on max row size and max no of columns that SQL allows to be created w/o paying too much price on performance. Also need help on Performance Monitoring and Optimization Tools on SQL2000. A few tips on good design practices will also be appreciated.
Pls do respond.
February 4, 2004 at 8:02 am
As for the checklist, db design practice:
http://www.microsoft.com/downloads/details.aspx?FamilyId=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en
As for the max rowsize:
http://www.sqlservercentral.com/columnists/sjones/pagesize.asp
As for max. no of columns:
Take a look at BOL for 'Maximum capacity specifications
As for performance monitoring:
Sorry, there you need to wait for other members. I'm not too familiar with it.
HTH
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 4, 2004 at 10:10 am
You are making what is unfortunately, a very common mistake. You are confusing logical and physical considerations.
You should focus first on the logical design of the database. Simply put this is the process of ensuring that the database properly reflects that subjective part of the business it is concerned with.
Only after you have arrived at a sound logical design should your attention turn to physical implementation and performance details.
There are no shortcuts to learning data management fundamentals, unfortunately there are far too many people who are willing (or forced) to ignore them. Do yourself, and your employer a favor and learn the fundamentals before you make a huge mistake.
Get a copy of Chris Date's "Introduction to Database Systems." This is not "Database Design for Dummies" it is a rigorous treatment of the subject.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
February 5, 2004 at 12:23 am
Get a copy of Chris Date's "Introduction to Database Systems." This is not "Database Design for Dummies" it is a rigorous treatment of the subject.
That's no beginners stuff! And might to a certain degree be contraproductive here. But I agree a VERY good book on the topic. Not cheap at ~$100.
Another book on database design, IMHO more appropriate for beginner, because of not being written from inside the ivory tower is 'Database Design for Mere Mortals (Second Edition)' von Michael J. Hernandez, Addison-Wesley; ISBN: 0-201-75284-0
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply