This SQL Optimizer for SQL Server video demonstrates how to improve your database performance through SQL optimization.
Related Articles
Oracle Tuning Sorts to Reduce I/O
A sort area in memory is used to sort records before they are written out to disk. Increasing the size of this memory by increasing the value of the initialization parameters SORT_AREA_SIZE or PGA_AGG...
ORA-01033 when Connecting to the DB Via Scan Listener
Had a very interesting and tricky scenario a few days ago. It was something I never encountered in my DBA career. Hence, thought of sharing the detail of there store here today. Challenge During m...
Why Don’t Universal Groups Work in SQL Server?
If you’ve tried using Universal Groups in Active Directory to access your SQL Servers, you may notice that the users who are members of these groups can’t access the SQL Server Instance. The reason fo...
