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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-13 : 05:00:01
|
| i. If we have files and filegroups in place we have improved performance on backup and restore .Can we have any other improved perfortmance ?2.If we are rebuilding or reorganising indexes on a table,which one will the degrades the performance more on the production server and which sits more on the transaction log.3 how can we check the tableid in the database. |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-13 : 06:33:05
|
| Actually these questions are asked in an interview. Its not the tableid it is object-idHow can we check the object-id for a particular table in a database. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-13 : 16:11:20
|
| 1. multiple filegroup doesn't improve db backup, but may backup filegroup individually. If you put files on separate disk arrays and number of files equals number of prosessores on the server, you'll get better db performance. 2. depends on how you look at it, sometimes rebuild index is required to improve query performance.3. query sys.sysobjects. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-14 : 05:08:34
|
| 3 Select object_id('tablename')MadhivananFailing to plan is Planning to fail |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-14 : 05:25:03
|
| 1. It depends on how you organized your files and filegroups across disks. But if you have disk array and you properly arranged your data and log files across array, you can get better I/O performance as well.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-14 : 10:37:29
|
| Rebuilding index,bulk-insert are logged operation and consumes log. |
|
|
|
|
|
|
some doubts