Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Frenkie

    Language problem after SP2

    Hi all, we using MSSQL2000 after applay SP2(english) I dont know how to change national language support (problem with weeks:-> US weeks not start in Monday). Anybody know how to solve this problem? thanks Frenkie
  2. Frenkie

    Server crash. Problem with Priv.edb.

    Hi vb8304, I not have any luck, but I snifing for any help. Was good document wrote about it for 5.5, but nothing for 2000. Also Microsoft say, you may rebuild your database when you have all log files, which I have, but they not say how. Maybe I found one possible way, but I don't know...
  3. Frenkie

    indexes vs. identity columns

    I think your design is OK. Usualy is good using NOT data but other column as PK, because all other data could be changed. Also index based on small data like int, or small int is better then using bigger. Processor faster compare 4 bytes against 4 bytes as comparing long strings.Also I read...
  4. Frenkie

    Two procesor problem

    I setting this column's value to null
  5. Frenkie

    Two procesor problem

    Thaks for tips tlbroadbent, foxdev. Here is more info about this problem. I updating one field in whole table with NULL value. I have also index for that field, but sometime this operation do it after 10min, 5 min, sometime for 20 min. I understand that this operation is depended on many...
  6. Frenkie

    Two procesor problem

    Hi all, I have two processor system with instaled SQL server. Sometimes this processors works on 100% somethimes on 1% on the same task. Why? Have anybody good advise how to powering this system? Also I have DB Tabe with 1.6 milion records. Is normal that Update takes about 20min? thanks, Frenkie
  7. Frenkie

    Server crash. Problem with Priv.edb.

    Hi all, my server (PDC with Ex2000) before few days crash.(file system was corupted) Was no any chance put it together. So I reinstall it. I have this crashed system on one disk and priv.edb, pub.edb on other disk. Question is how to get data from priv.edb and pub.edb and insert it to new...

Part and Inventory Search

Back
Top