Database Research & Development : dbrnd.com

New post (PostgreSQL: How to Delete all duplicate rows Except one) has been published on Database Research & Development

PostgreSQL: How to Delete all duplicate rows Except one Database Research & Development: Shared one small demonstration to delete duplicate records except one in PostgreSQL. I have prepared this query using ROW_NUMBER() PARTITION BY Clause.

New post (SQL Server: How to compare your objects between two Databases) has been published on Database Research & Development

SQL Server: How to compare your objects between two Databases Database Research & Development: Shared one T-SQL Script to compare the SQL Server objects like: Table, View, Stored Procedure, Trigger between the databases. It helps to DBA for making the all databases in sync.

New post (SQL Puzzle: SQL Advance Query - Generate the group of Sequences) has been published on Database Research & Development

SQL Puzzle: SQL Advance Query – Generate the group of Sequences Database Research & Development: Shared a SQL puzzle to generate the group of sequences of given data.

New post (PostgreSQL: Disable Non-Durable parameters and Improve Server Performance) has been published on Database Research & Development

PostgreSQL: Disable Non-Durable parameters and Improve Server Performance Database Research & Development: Shared few important Non - Durable parameters which we can disable for achieving the good performance PostgreSQL Database Server. Do only on your ad-hoc server.