Forum Replies Created

Viewing 15 posts - 2,476 through 2,490 (of 7,429 total)

  • RE: Another easy question

    Not sure what to tell you, maybe I would press the teacher to make a bit clearer.

  • RE: Date Constraint

    I would like to point out that Jonathan is converting to the ISO date format which is better than other date formats as it is not likely to fail when...

  • RE: Log file

    No the only thing logged is data change events (INSERTs, DELETES, UPDATEs and depending on settings bulk transactions). However you can also find info on table truncations and a few...

  • RE: Another easy question

    Can you elaborate a bit more as this is really not enough info to tell you the result of what you are looking for. Is there anything that causes two...

  • RE: Composite Keys

    You can make the natural key a composite unique non-clustered constraint (index) to get the performance and uniqueness in addition to a clustered articficial key with an int (or the...

  • RE: Performance degarded when changing system time?

    I have had to resync the time periodically and noticed that with SQL 7 there seemed to be a lag with SQLs time vs Windows new time (3 to 20...

  • RE: MS03-031 does not correctly detect restart

    I have done this one 4 machine specifically and none have seen this issue. All were live when started.

  • RE: Auto Close Database Option

    It will cause a lot of headaches. When all connections from the database end the DB closes and all it's info is flushed from the cache, when someone reconnects then...

  • RE: server connection

    That helps, now is your friends machine XP. If so there are known issues without SP1 in general and known issues when the password is changed with regards to registrations....

  • RE: keep last three backups in a file.

    First off I would do seperate files. The reason is if the file is damaged it effectively makes the whole thing useless.

    Now as for you question

    From BOL

    October 10, 2003 at 7:09 am

    #477837

  • RE: What is the best way to learn SQL?

    Expect no phone and it is limited to 1 user license. Went back today and looks like the CDs are no longer available (cute little ones) but the downloads are...

  • RE: server connection

    Maybe I am the only one but what does m/c stand for?

  • RE: Error 8929 and RID

    A RID is the following

    Row identifier of the locked row within the table. The row is identified by a fileid:page:rid combination, where rid is the row identifier on the page.

    1...

  • RE: What is the best way to learn SQL?

    Reading will help you understand concepts and theories used in the language. The best way thou to really understand it is to put what you read into practice and and...

  • RE: What is the best CD training program

    We just got the series from AppDev http://www.appdev.com/ haven't had a chance to open yet but is supposed to be top notch based on comments from other groups.

Viewing 15 posts - 2,476 through 2,490 (of 7,429 total)