Useful tips for everyday
What is PIVOT in SQL Server? The pivot column is the point around which the table will be rotated, and the pivot column values will…
What does allow multiple values mean in access? Allow Multiple Values. Indicates whether the lookup field allows multiple values to be selected. You cannot change…
What is horizontal partitioning sharding? 1 Horizontal partitioning — also known as sharding It is a range-based sharding. You put different rows into different tables,…
How do RDS Read Replicas work? The read replica operates as a DB instance that allows only read-only connections. Applications connect to a read replica…
What is the use of trigger in PostgreSQL? A “trigger” is defined as any event that sets a course of action in a motion. In…
What is the shortcut to remove duplicate values from the selected column? Alternatively, you can also use shortcut key: Alt + H + L. When…
Should we index status column? If you have other fields in the where clause, a composite index should work better. Having the status field there…
How do I map in SQL? Mapping columns On the Table mapping tab, click the Status box of a Partial mapping. A dialog box is…
What to do if SQL Server installation fails? This article helps you resolve the problem that occurs when you install or upgrade Microsoft SQL Server…
What is the difference between group and role in AWS? Remember : Groups are for living. Roles are for non-living. Role is like a tag…