Forum Replies Created

Viewing 15 posts - 61 through 75 (of 130 total)

  • RE: Windows Security

    Ah, but if it were only the cost of the OS you'd be right. How long was the list of Win2000 compatible software that would not work under XP? How...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Scheduled Job started bud nothing happens

    Here's something strange to try: Set the SQL Server Agent to run with your account and see if you can get the scheduled job to run.

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Windows Security

    Two words: Planned Obsolescence

    Since Microsoft does not charge for updates, upgrades, etc...to existing systems (OS or Server) it eventually comes to a point where Microsoft is no longer making money...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: cannot open connection to analysis server ''''servername''''

    You mentioned this is one a cluster. I assume you are using Microsoft Cluster Services (MSCS). Is this an active-active or active-passive? Is it possible that the T drive is...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Scheduled Job started bud nothing happens

    A few quick questions:

    You mention multiple connections. Are any of these to oracle servers or do any of them require a client be installed on the SQL server to make...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Veritas Backup

    Yeah, the SQL-Litespeed-Disk-Tape process is great. Small, fast backups that work very closely to the native SQL backups.

    Love LiteSpeed.

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Veritas Backup

    You are right. The correct order is the issue.

    Say you alternate TLog backups to tape and to disk every hour for 16 hours during the day. 8 go to tape,...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: 911: developers insist PK/FK constraints impede performance

    I think we are blurring the line between business rules and data integrity rules.

    DRI probably should not be used to enforce business rules beyond the very basic ones that...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Veritas Backup

    Database backups to tape and TLog backups to disk should be okay. What you cannot do is backup TLogs to tape sometimes and TLogs to disk sometimes. This will cause...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Veritas Backup

    Here's a question: How do you backup to disk and to tape without losing checkpoint information?

    I assume you are not doing transaction log backups and your databases are not...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Veritas Backup

    All I can tell you is that I spent the better part of 3 months trying to get it to work (this was NetBackup 4 for Windows) and we eventually...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: Upsizing a ms Access database to MS SQL

    James, have you verified with the hosting provider that they allow you to connect via port 1433 from the Internet. They may not allow those connections.

    Their support people may be...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: 911: developers insist PK/FK constraints impede performance

    I guess the correct answer is "it depends". The right way should be a blend of good practice, data integrity and business need.

    Likewise, no one should ever say "DRI...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: 911: developers insist PK/FK constraints impede performance

    I agree. I've never seen a database with cascading deletes turned on. Nowadays, it is pretty much taboo to really delete anything anyway versus just marking it deleted so it...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

  • RE: 911: developers insist PK/FK constraints impede performance

    Quick Survey:

    How many people here use DRI and have never worked with a database system that didn't have DRI capability?

    How many people here do not use DRI and started their...

    -- J.T.

    "I may not always know what I'm talking about, and you may not either."

Viewing 15 posts - 61 through 75 (of 130 total)