View Poll Results: what is your favorite color
- 0. You may not vote on this poll
11-09-03, 22:52 #1Registered User
- Join Date
- Oct 2003
Unanswered: tablespace size in mssql possible?
i use ms sql 2000 server
the customerprofile table i used grow rapidly , i need to scrub data in this table and search regularly by phone and customerid. i have used two index for phoneno and customerid seperately, but query execution is still very slow. shrinking database is placed as a part of maintenance plan. how do i make it fast?
is it possible using custom tablespace size in our choice ?