Useful Microsoft SQL-Server Commands

mssql_index.sql

-- ----------------
-- Reorganize Index
-- ----------------
USE MYDATABASE;
GO
EXECUTE sp_msForEachTable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REBUILD;'
GO
EXECUTE sp_msForEachTable 'SET QUOTED_IDENTIFIER ON; ALTER INDEX ALL ON ? REORGANIZE;'
GO

-- -------------------
-- Show Database Files
-- -------------------
USE MYDATABASE;
SELECT * FROM sys.database_files;

-- --------------------------
-- Shrink SQL Server Log File
-- --------------------------
USE MYDATABASE;
GO
ALTER DATABASE MYDATABASE SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE('Log01',1);
GO
ALTER DATABASE MYDATABASE SET RECOVERY FULL;
GO