IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi, I will share SQL Server DBA Scripts in this post.
Read More »SQL Server DBA Scripts All in One – Useful MS-SQL ( DBA ) Database Administration Scripts
Tag Archives: SQL Server Collection Inventory Script
SQL Server Update Database Statistic
Hi, Database objects stats should be up to date for making the right decision of SQL Server optimizer.
Read More »SQL Server Rebuild and Reorganize Index
Hi All Indexes in the SQL Server database will be fragmented After related tables got many update, delete transactions.
Read More »SQL Server Unused Index
Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.
Read More »SQL Server Collection Inventory Script -3
Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.
Read More »SQL Server Database Size Growth using Backup history
Hi, Managers and customers are asking frequently what is the database size growth.
Read More »SQL Server Collection Inventory Script -2
Hi, You want to learn all Inventory of SQL Server when you connect to SQL Server database for the first time.
Read More »SQL Server Database Objects Statistics
Hi, Database objects stats should be up to date for making the right decision of SQL Server optimizer.
Read More »SQL Server Active Sessions and Status
Hi, Most frequently task of DBA is monitor database and which session is active and which is inactive or which one is blocked.
Read More »SQL Server Index Usage Stats
Hi, SQL Server DBA should monitor all indexes and which of indexes are using and which are not.
Read More »