Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram for a specific stat which actually is also available with the latest Cumulative Update for SQL Server 2016 Service Pack … Continue reading
Tags: SQL Server
Related Articles
How to use object wizard in Toad Edge
This video walks through the object wizard functionality in Toad Edge. The object wizard is a GUI that guides user through the process of creating database objects. Users are show an example of fully ...
Session Cursor Caching – Part One
Introduction When a SQL statement is issued, the server process, after checking its syntax and semantics, searches the library cache for an existing cursor for the SQL statement. If a cursor does not ...
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...
