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
Oracle Sizing Rollback Segments for Long-running Jobs
Like tables and indexes, rollback segments may run out of space during processing and need to request additional extents. Dynamic extension can have a serious impact on performance, particularly on th...
SQL SERVER – Powershell Script – Remove Old SQL Database Backup Files...
Few days back I wrote blog to help my blog reader and this is follow up on the same post How to Add Date to Database Backup Filename? – Interview Question of the Week #109. In this blog post we will s...
An Illustration of JSONB Capabilities in Postgres 9.5
Postgres introduced JSON and JSONB in versions 9.3 and 9.4, respectively, with JSONB (Binary Javascript Object Notation) being the canonical form of JSON, stored as binary objects with improved compre...
