Part of the SQL Server 2022 blog series. The main difference between tempdb and other databases is the workload. With tempdb we are constantly creating and destroying objects such as temp tables. This ...
Earlier in 2023, we discussed The Importance of Metadata here in the DBA Corner column. And, indeed, metadata is more important than ever before because it helps us to understand our data. Data ...
SELECT DBMS_METADATA.GET_DDL('TABLE', '&tblNAME', '&Owner') FROM DUAL; ...
Merge replication metadata is cleaned up periodically by the Merge Agent based on the retention setting for the publication. This occurs at the Publisher and ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results