Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Generate Create All Secondary Indexes For Entire Database

    Andrew-

    This does not add indexes to all columns. Where did you get that idea?? What were you reading? There is no blindly adding here!!!!

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

  • RE: Changing SQL port

    Yep, Cluster aware components are ones that are written to support the Cluster API's. These API's include the following:

    Cluster API - Works with the Cluster Objects and the Cluster...

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

  • RE: Changing SQL port

    When you install on a cluster and you indicated that you are installing a failover clustered instance the installation process will install the necessary components on all members (servers) in...

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

  • RE: Changing SQL port

    Be very careful changing the port on a cluster. Make sure that the port is indeed available. If it is not and you assign the port number of...

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

  • RE: long running stored procedure

    Try increasing your network package size under the Connections Tab of Query Analyzer's Options

    Gary L. Fry
    Senior Database Administrator III
    MCTS, MCITP SQL Server 2008 Database Administration
    Colonial Life/UNUM

Viewing 5 posts - 1 through 6 (of 6 total)