Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Computer Forums > Programmers Lounge > Programming Discussions » Indexing and MSSQL 2000 Performance
Closed Thread
Old 07-18-2005, 07:06 AM   #1 (permalink)
 
Junior Techie

Join Date: Dec 2004

Posts: 88

developer

Default Indexing and MSSQL 2000 Performance

Can anyone post a link to SQL server 2000 tips on indexing for better database performance and on how to use this facilty.

Is the indexing service a big hit on the performance? Is there a workaround in SQL?
__________________
Somewhere I Belong...
developer is offline  
Old 07-18-2005, 02:48 PM   #2 (permalink)
 
Junior Techie

Join Date: Dec 2004

Posts: 88

developer

Default

Well i found some articles on this. And now understand that whateever be the performance sometimes its inevitable.

Well can some one please tell me how to update my catalog and index time to time? This is some kind a problem as i dont understand it properly yet.
__________________
Somewhere I Belong...
developer is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On