Database Optimization - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Database Optimization

Author

Topic

mbevon
Starting Member

41 Posts

Posted - 2003-04-22 : 14:42:14

What's Database Optimization?

thanks
mb

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2003-04-22 : 14:59:34

Among other things... Properly indexed tables. Optimal data placement (e.g. file groups, RAID). Elimination of bottle necks within the DBMS. And depending on your fervor proper adherence to RDBMS tenets such as normalization.

That is just a broad overview and not an all encompassing list.

Justin

"Take care of yourself and do night fight with pygmies" - RT

Edited by - justinbigelow on 04/22/2003 15:00:19

X002548
Not Just a Number

15586 Posts

Posted - 2003-04-22 : 15:16:33

Whats a database?

Brett

8-)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-04-22 : 15:49:13

[url]http://www.amazon.com/exec/obidos/tg/detail/-/1555582419/qid=1051040951/sr=1-1/ref=sr_1_1/002-4436912-3781663?v=glance&s=books[/url]

Tara

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-04-22 : 19:27:02

I prefer,

http://www.amazon.com/exec/obidos/ASIN/0764508180/qid=1051053805/sr=2-3/ref=sr_2_3/102-7896010-3642565

or

http://www.amazon.com/exec/obidos/tg/detail/-/0595138209/qid=1051053862/sr=1-6/ref=sr_1_6/102-7896010-3642565?v=glance&s=books

or

http://www.amazon.com/exec/obidos/tg/detail/-/9992651601/qid=1051053862/sr=1-10/ref=sr_1_10/102-7896010-3642565?v=glance&s=books

or

http://www.amazon.com/exec/obidos/tg/detail/-/1552561704/qid=1051053862/sr=1-8/ref=sr_1_8/102-7896010-3642565?v=glance&s=books

or

http://www.amazon.com/exec/obidos/tg/detail/-/0385495935/qid=1051053862/sr=1-4/ref=sr_1_4/102-7896010-3642565?v=glance&s=books

or

http://www.amazon.com/exec/obidos/tg/detail/-/1570231915/qid=1051053862/sr=1-2/ref=sr_1_2/102-7896010-3642565?v=glance&s=books

But Seriously,
Here is a good formula

http://www.amazon.com/exec/obidos/tg/detail/-/0201700468/ref=pd_sim_books_3/102-7896010-3642565?v=glance&s=books

Read all the sql team articles

Read at least 50 forum topics a day

Try to answer questions.

Get confused and start again with more books.

Edited by - ValterBorges on 04/22/2003 19:31:33

Edited by - ValterBorges on 04/22/2003 19:32:07

X002548
Not Just a Number

15586 Posts

Posted - 2003-04-23 : 10:51:07

LOL....

But quitting your job may not be an option in this market....you may be out of work before you can.

What's a database?

Brett

8-)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources