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.
| Author |
Topic |
|
abcd
Yak Posting Veteran
92 Posts |
 Posted - 2009-01-12 : 03:09:03
|
| hi all.....i have a very general question....how do people manage large datbases in sql server 2005...what are the best practises one should follow during all the processing????do help.... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-12 : 03:13:37
|
| best practises regarding what? can you be more specific? |
 |
|
|
ashishashish
Constraint Violating Yak Guru
408 Posts |
Posted - 2009-01-12 : 03:18:12
|
| hi,,,,,,,,,Make BackUp of databases as a habit.,...mean its necessary to take BackUp of your databases.... regularly,,,,,,,make proper indexes on Tables and all,,,,,and other there are to many experts to guide you here....they guide u in very good way as u want,,,Thanks,,,,n Take backup. |
|
|
|
abcd
Yak Posting Veteran
92 Posts |
Posted - 2009-01-12 : 04:04:21
|
| sir best practices regarding fast execution of queries and handling large database in evrey respect...i wonder how these big websites handle the data and yet execution time is so less.....i was goin through some articles about this,,,main points given were to make use of indexes,table partitioning....i went through table partitioning articles n read about partiotioning keys,schemeas anf partition functions....the problem is that i am unable to fully understand all matter given...do guide.... |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-01-12 : 05:34:26
|
| This free ebook: 'Pro SQL Server 2005 High Availability' covers the topic. http://www.red-gate.com/products/sql_response/offers/allan_high_availability_ebook.htm |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-12 : 08:50:48
|
quote:
Originally posted by abcd
sir best practices regarding fast execution of queries and handling large database in evrey respect...i wonder how these big websites handle the data and yet execution time is so less.....i was goin through some articles about this,,,main points given were to make use of indexes,table partitioning....i went through table partitioning articles n read about partiotioning keys,schemeas anf partition functions....the problem is that i am unable to fully understand all matter given...do guide....
Have you tried implementing them? Maintenance of index,processors,Memory,disk systems and other things play major role in it. |
|
|
|
|
|
|
|
|
best practices to handle large database