Forum Replies Created

Viewing 15 posts - 32,221 through 32,235 (of 39,748 total)

  • RE: One Major Dbase V Many Small Dbs

    I definitely lean towards multiple databases, 1 per app, especially for scalability in case one client outgrows the system or causes issues for others.

    However, there have been some good points...

  • RE: Applications which require dbo access to run

    The basic answer is that you don't grant more permissions than are necessary. DBO can do pretty much anything inside the database, backup/restore, grant new users rights, change security, etc....

  • RE: Resetting Counters

    Do you mean the voting?

    Or something different?

  • RE: Who Can Program?

    Some great comments and things to think about. I was really interested to see what you might think because I think we'll always have jobs.

    MDX is a language for cubes...

  • RE: Is Computer Science Dead?

    Antares, I agree with that.

    No calculators in school!

  • RE: Hardware Patches

    You and I both!

  • RE: The IT Career

    I don't think any of this will fade away. Are cars that much better than they were 30 years ago? I still see lots of mechanics out there.

    I know TVs...

  • RE: Ten Ways To Lose Your DBA Job

    Thanks for the comments and that's a great idea for 10 ways to get promoted. I'll work on that one. Not sure I have 10 ways, but I have a...

  • RE: Question of the Day for 13 Apr 2007

    Leaving aside the nonsense on the builds and the apparent confusion from MS on what fixes what.

    I still stand by the answer that you only need to apply the latest...

  • RE: Transferring SQL Server Logins

    Can't keep SIDs, but you can use sp_help_revlogin to script out and move logins with the same passwords.

  • RE: How to retrieve the path of errorlog?

    It's a parameter in the service startup, so it should be in the registry. You can get it from xp_regread or any registry scripting

  • RE: The IT Career

    But did you get to keep the red stapler?

    I think I was there in the closet/turned server room. Just behind the rack to the left.

  • RE: Question of the Day for 13 Apr 2007

    Hugo, I'm not sure that invalidates the answer. Whether you are on the QFE track or the GDR track, you only apply the latest hotfix that you want to apply....

  • RE: Regular Patches

    This is close to what I've been asking for. I was hoping for quarterly service packs, but rollup hotfixes work just as well.

    Plus they shouldn't have features!

  • RE: How to determine the total space of all drives on a server?

    xp_fixeddrives

    Or maybe use VBScript and the FileSystemObject. That might be the easiest.

Viewing 15 posts - 32,221 through 32,235 (of 39,748 total)