Forum Replies Created

Viewing 15 posts - 16 through 30 (of 42 total)

  • RE: A question about servers

    What is the rationale given for consolidating to one box? What is broken about the current setup?

    Is that box going to be in the DMZ?

    How will the equivalent functionality be...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Is there is any way to know number of spindles present in the HardDisk?

    Only your vendor knows for sure.

    If you built it from parts you will have to contact the hard drive manufacturer and get the specs from them.

    You asked about an extended...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Moving SQL Server!

    Hi Bruno,

        Just to weigh in from the MS PSS section. The article Frank linked is what we would have given you had you called in for assistance.

    You can detach...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Error: 823, Severity: 24, State: 2

    Hi,

        Alok is correct. This is a sign of hardware problems. Before you try to restore your databases you REALLY should get some technical help for the hardware. Sql Server does...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: QOD 17th Nov

    ALright floks, Let's hear from the guys running this show. What is your reference for this particular question. This answer looks suspiciously like someones interpetation of what the...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: How old are you?

    To read some of the posts in this thread it would be easy to believe that getting older is a bad thing. I'll be 44 in March. Have...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Server Farm

    Hi aurora01,

    That's a lot easier as the concepts of a server farm apply much more easily to web and application servers.

    For the...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Using mssqlXpress Good or Bad

    Hi robinhc,

    I tested it earlier this year. I will admit that it has some nice features. I would not call it...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Server Farm

    Hi aurora01,

    Just from the way Sql Server works the only way I could see this working would be to use federated servers. Each...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Restores of SQL Server to another server

    If you still have access to the original server you can do a Sql Backup or if the Sql install is hosed you can do an...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: multi-db backup

    You should look at the BOL (Books Online) topics for Backup Database and sqlmaint.exe.

    Backup Database is a T-Sql command that you would execute from a...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: ERROR 1204

    Hi KStefan

    You need to look at a couple of things.

    How much memory is available? How much virtual memory is Sql Server tring...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Reaching the Outer Limits

    Hi Steve,

    Great article. Especially the steps you went through for tracking down the true reason for the error. I have always wished...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: Where Do I Want To Go Today? - Rich Data Types

    Steve,

    This functionality is already available in Site Server and whatever followed it (Commerce Server, I think.) It catalogs the objects and you...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

  • RE: After sp3a I can't save changes to dts packages

    quote:


    I believe you are missing user data in your old master database. Among such data is the associaton between a login...

    Richard L. Dawson
    Microsoft Sql Server DBA/Data Architect

    I can like a person. People are arrogant, ignorant, idiotic, irritating and mostly just plain annoying.

Viewing 15 posts - 16 through 30 (of 42 total)