G2A Many GEOs
SHARE
TWEET

Untitled

SQLSoldier Aug 18th, 2013 84 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
Ledger Nano X - The secure hardware wallet
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top