Microsoft SQLServer DBA (Database administrator)

juhanak.cz » database » sqlserver » dba

Pro adminstraci SQLServer databází mám v oblibě několik skriptů.

Database

• take_offline.sql

Adhoc skripty

• catalog.sql
• instance_params.sql
• audit.sql
• backup_info.sql
• privs.sql

Objects

• freespace.sql

Performance

• rebuild_index.sql

Blocked processes

• blocked_sysprocesses.sql

Drop datafile
-- shrink datafile to empty size by migrate content to other datafiles in group
-- issue folowing statement
ALTER DATABASE DB_NAME REMOVE FILE LOGICAL_FILENAME