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 |
|
bjornh
Yak Posting Veteran
87 Posts |
 Posted - 2003-10-19 : 15:54:05
|
For testing/developing iam using an old server (a old desktop, pIII450, 256mb  ), that's what you get if your working for a starting up business :)but for production, were using a hired server, with more power...so far, the intro... now the question: If i create an index 'plan' on my test server, that is optimum, is it still optimum for the production server, or is hardware an issue?thanks again  (I love SQLteam.com  ) |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-19 : 16:04:24
|
| You may find that you don't need some indexes and removing them would make data updates more efficient.You may find issues with parallelism if you have multiple processors on the new system.Apart from that there shouldn't be much difference.If you don't have a test system that matches the spec of the live one then there's not much you can do other than hope - you probably should tell whoever is in charge of budgets that this is a risk.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
bjornh
Yak Posting Veteran
87 Posts |
Posted - 2003-10-19 : 17:26:04
|
| ok, so it still is pretty representive...and yeah i told him (about every day the last year , because i can think of 100 of things that would go smoother), but his willing to take the risk, starting up a business is hard enough allready, so sometimes you need to make choices were to spend your money... |
|
|
|
|
|
|
|
|
new indexes for new hardware?