Tempd DB resize (modify size) using script

use master
 go

 alter database tempdb modify file
  (name = tempdev,
  size = 8192MB,
  maxsize = 10241MB,
  filegrowth = 2048MB)
 go

 

 alter database tempdb modify file
  (name = templog,
  size = 512MB,
  maxsize = 1025MB,
  filegrowth = 256MB)
 go
 checkpoint
 go