SHARE
TWEET

Untitled

SQLSoldier Aug 18th, 2013 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. USE master;
  2.  
  3. ALTER DATABASE AdventureWorksDW2012 ADD FILEGROUP IndexFG;
  4. ALTER DATABASE AdventureWorksDW2012 ADD FILE (
  5.         NAME = N'IndexFile',
  6.         FILENAME = N'D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\IndexFile.ndf',
  7.         ) TO FILEGROUP IndexFG;
  8. GO
  9.  
  10. Use AdventureWorksDW2012;
  11.  
  12. ALTER INDEX IX_FactIneternetSales_ShipDateKey On dbo.FactInternetsales Disable;
  13. Go
  14.  
  15. CREATE INDEX IX_FactIneternetSales_ShipDateKey On dbo.FactInternetsales (ShipDateKey)
  16.         With (Drop_Existing = On)
  17.         On IndexFG;
  18. Go
RAW Paste Data
Pastebin PRO Summer Special!
Get 40% OFF on Pastebin PRO accounts!
Top