Tags » SQL Performance

Random Notes on Direct Path Reads

We have been experiencing performance problems after upgrading to Oracle RDBMS 11.2.0.3 and 11.2.0.4 due to high Direct Path Read events. This post is a selection of MOS documents that could be relevant to our problems. 570 more words

Oracle RDBMS 11

SQL Tidbit : NOCOUNT

In a store procedure that has loops or doesn’t have much output, setting ‘NOCOUNT ON’ will boost performance, as it wouldn’t send the count of rows affected to the client. 9 more words

SQL SERVER - 8 Performance Related Articles on Logical Reads

Earlier this year, I have written few articles which are related to SQL Server Performance and they are published on site of Logical Reads. Here are my personal favorite 8 various articles on the subject of SQL Server Performance. 556 more words

SQL Authority

SQL SERVER - Configuration and Performance of SQL Server is Now Easy to Master

This is one of the toughest topics to address, and I am always looking at new tools that can help me learn and understand SQL Server better. 1,392 more words

SQL Authority

SQL SERVER - Year 2014 Reflections by Tim Radney - Notes from the Field #060

[Notes from Pinal]: New Year’s Resolutions is a funny word. Everybody makes it on January 1st but breaks it in very few days. I used to make resolutions too, but for a while, I have stopped this practice. 672 more words

SQL Authority