2,187
edits
Difference between revisions of "MS SQL"
Jump to navigation
Jump to search
→Commands and Maintenance: Added SELECT name,log_reuse_wait_desc FROM sys.databases;
m (→Fragmentation: added ent note) |
(→Commands and Maintenance: Added SELECT name,log_reuse_wait_desc FROM sys.databases;) |
||
| Line 143: | Line 143: | ||
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME LIKE '%' /* Show tables */ | ||
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' /* Show base tables only (not views etc) */ | ||
EXECUTE sp_who2; /* Show current | EXECUTE sp_who2; /* Show current processes */ | ||
SELECT name,log_reuse_wait_desc FROM sys.databases; /* Show why transaction log can't grow */ | |||
</source> | </source> | ||
/ | |||
=== Manual Backup === | === Manual Backup === | ||
<source lang="sql"> | <source lang="sql"> | ||