Script to Move Indexes off of the Primary Filegrou

This is a stored proc that will move your indexes to two new file groups. A Cindex file group is for the clustered indexes and NCindex file group is for non clustered indexes. The parameters for this procedure are @CPATH - the path to the clustered index datafiles @NCPATH - the path to the nonclustered […]

1 (1)

2005-04-29 (first published: )

372 reads

Blogs

Microsoft Ignite Announcements 2021

By

Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Read the latest Blogs

Forums

combine two interval tables into single result set

By rbroersma

Hello, Looking for help combining two interval tables together.  The tables are pretty simple......

How can do a loop select stmt from this folowing table

By aggy_02_20

Hi..How can do a loop statement for the following table first loop shld be...

Azure SQL Managed Instance Features

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Azure SQL Managed Instance Features

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers