LEFT JOIN DBA_TS_QUOTAS q ON u.USERNAME = q.USERNAME LEFT JOIN DBA_ROLE_PRIVS r ON u.USERNAME = r.GRANTEE ...
This stored procedure converts a table or select query to a HTML table format, with some customization options. I have taken as a base, a script Carlos Robles (dbamastery.com) provided me for a static ...
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 ...