In this SQL Optimizer for SAP ASE video, we demonstrate how the Index Impact Analyzer shows the impact of adding or removing an index to a SQL statement.
Related Articles
How to monitor database activity with the Toad® Database Browser Utility
Memory usage, database parameters and options, user session information, and rollback activity. These are just a few of the things that you are responsible for. As a DBA there is a lot of activity ...
SQL SERVER – DBCC SHRINKFILE: Page 1:26423878 Could not be Moved...
This blog is an outcome of an email communication with my client. The issue was that they were having big tempdb files. They had multiple files and of uneven size. As soon as they restart SQL, the ini...
Rising Above Without Sinking Below
Rising Above The data professionals I've had the honor of working with are some of the most dedicated people I know. There have been several occasions in my life when a hard deadline has been mandate...
