kashiash

use timex8_I

ALTER DATABASE Timex8_I SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(Timex8_I_log, 1) --,truncateonly)
ALTER DATABASE Timex8_I SET RECOVERY FULL WITH NO_WAIT

kashiash

EXEC sp_updatestats; 

-- Missing Index Script
-- Original Author: Pinal Dave 
SELECT TOP 25
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
dm_migs.last_user_seek AS Last_User_Seek,
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) AS [TableName],
'CREATE INDEX [IX_' + OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) + '_'

kashiash

Set-ExecutionPolicy Unrestricted -Force

. { iwr -useb https://boxstarter.org/bootstrapper.ps1 } | iex; get-boxstarter -Force

choco install notepadplusplus.install -y
choco install totalcommander -y
choco install firefox -y
choco install microsoft-edge -y
choco install opera -y
choco install sysinternals --params "/InstallDir:C:\SysInternals" -y

kashiash

choco install 7zip.install -y
choco install firefox -y
choco install opera -y
choco install notepadplusplus.install -y
choco install teamviewer -y
choco install pdfxchangeeditor -y



choco install postman -y