Greenplum: How to reset the Priority of Running Statement or Transaction?

In this post, I am sharing one of the important articles on how to reset the priority of running or active statement of Greenplum. The Work Load management of Greenplum means – define the different Resource Queues with options like priority, memory, CPU. RQ associates with the user and all statement of this user will […]

November 7, 2017 Greenplum

November 6, 2017

SQL Server 2016: New COMPRESS and DECOMPRESS function for the Column level Compression

November 5, 2017 5

SQL Puzzle: SQL Advance Query – Reduce duplicate column data by merging ID with it

November 4, 2017

SQL Server: How to Remove Forwarded Records of a Heap Table?

November 3, 2017

SQL Server: Script to find the Forwarded Records count of a Table

November 2, 2017

SQL Server: Must know – the Forwarded Records in HEAP Table

November 1, 2017

SQL Server Interview: Theory – What are the different states of Database

October 31, 2017 1

SQL Puzzle: SQL Advance Query – Search the percentage (%) character in table

October 30, 2017 2

SQL Puzzle: SQL Advance Query – Display Year and Month data With or Without PIVOT

October 29, 2017 1

SQL Puzzle: SQL Advance Query – Print START before group and Print END after group

Older posts Newer posts

About Me!