Professional Web Applications Themes

Convert index to clustered - Microsoft SQL / MS SQL Server

You can use CREATE INDEX with DROP_EXISTING option to create a new index if there is already one in place. Since you are building a clustered index, you will have to rebuild any other existing non-clustered indexes on the table again. Refer to SQL Server Books Online for more details. -- - Anith ( Please reply to newsgroups only )...

  1. #1

    Default Re: Convert index to clustered

    You can use CREATE INDEX with DROP_EXISTING option to create a new index if
    there is already one in place. Since you are building a clustered index, you
    will have to rebuild any other existing non-clustered indexes on the table
    again. Refer to SQL Server Books Online for more details.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

  2. #2

    Default Re: Convert index to clustered

    But I cannot use drop existing with referential constraints in place. I was
    wondering if there is a way to create the index but without all the problems
    of having to re-create 20+ constraints referring to other tables.

    "Anith Sen" <anithbizdatasolutions.com> wrote in message
    news:uv$maK8RDHA.3132tk2msftngp13.phx.gbl...
    > You can use CREATE INDEX with DROP_EXISTING option to create a new index
    if
    > there is already one in place. Since you are building a clustered index,
    you
    > will have to rebuild any other existing non-clustered indexes on the table
    > again. Refer to SQL Server Books Online for more details.
    >
    > --
    > - Anith
    > ( Please reply to newsgroups only )
    >
    >

    London Developer Guest

  3. #3

    Default Re: Convert index to clustered

    If you make the change in EM and don't save it you can hit the toolbar
    button (3rd from the left I believe) that says "Save change Script" to see
    how EM handles it. It may not be the most efficient approach but it will
    give you all the code.

    --

    Andrew J. Kelly
    SQL Server MVP


    "London Developer" <devnowhere.com> wrote in message
    news:%23PFBPf8RDHA.2020TK2MSFTNGP11.phx.gbl...
    > But I cannot use drop existing with referential constraints in place. I
    was
    > wondering if there is a way to create the index but without all the
    problems
    > of having to re-create 20+ constraints referring to other tables.
    >
    > "Anith Sen" <anithbizdatasolutions.com> wrote in message
    > news:uv$maK8RDHA.3132tk2msftngp13.phx.gbl...
    > > You can use CREATE INDEX with DROP_EXISTING option to create a new index
    > if
    > > there is already one in place. Since you are building a clustered index,
    > you
    > > will have to rebuild any other existing non-clustered indexes on the
    table
    > > again. Refer to SQL Server Books Online for more details.
    > >
    > > --
    > > - Anith
    > > ( Please reply to newsgroups only )
    > >
    > >
    >
    >

    Andrew J. Kelly Guest

  4. #4

    Default Re: Convert index to clustered

    Good idea! Thanks for that, I'll see if it'll help.

    "Andrew J. Kelly" <sqlmvpnooospamshadhawk.com> wrote in message
    news:ei1FBy8RDHA.1720TK2MSFTNGP10.phx.gbl...
    > If you make the change in EM and don't save it you can hit the toolbar
    > button (3rd from the left I believe) that says "Save change Script" to see
    > how EM handles it. It may not be the most efficient approach but it will
    > give you all the code.
    >
    > --
    >
    > Andrew J. Kelly
    > SQL Server MVP
    >
    >
    > "London Developer" <devnowhere.com> wrote in message
    > news:%23PFBPf8RDHA.2020TK2MSFTNGP11.phx.gbl...
    > > But I cannot use drop existing with referential constraints in place. I
    > was
    > > wondering if there is a way to create the index but without all the
    > problems
    > > of having to re-create 20+ constraints referring to other tables.
    > >
    > > "Anith Sen" <anithbizdatasolutions.com> wrote in message
    > > news:uv$maK8RDHA.3132tk2msftngp13.phx.gbl...
    > > > You can use CREATE INDEX with DROP_EXISTING option to create a new
    index
    > > if
    > > > there is already one in place. Since you are building a clustered
    index,
    > > you
    > > > will have to rebuild any other existing non-clustered indexes on the
    > table
    > > > again. Refer to SQL Server Books Online for more details.
    > > >
    > > > --
    > > > - Anith
    > > > ( Please reply to newsgroups only )
    > > >
    > > >
    > >
    > >
    >
    >

    London Developer Guest

Similar Threads

  1. clustered CF services
    By johnnyTarr in forum Coldfusion Server Administration
    Replies: 0
    Last Post: December 2nd, 01:21 AM
  2. cfchart clustered bar chart
    By gogl in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: October 13th, 08:26 PM
  3. can CFCHART be used in a Clustered Envrionment
    By jcameron in forum Macromedia ColdFusion
    Replies: 0
    Last Post: June 18th, 08:25 PM
  4. Replies: 4
    Last Post: August 3rd, 03:11 PM
  5. Clustered web farm
    By sudha in forum ASP.NET General
    Replies: 3
    Last Post: July 10th, 12:35 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139