Useful tips for everyday
What do you need to know about PostGIS schema? Inside that schema, the default install of PostGIS creates the geometry_columns, geography_columns and spatial_ref_sys metadata relations,…
How do I randomly sort rows in Excel? Select the column filled with random numbers by clicking on the initial row letter at the top.…
How do you update a table in pgAdmin 4? To view or modify data, right click on a table or view name in the Browser…
Can 32-bit and 64 bit Oracle clients coexist? If are still running on PeopleTools 8.53 (or earlier), you’ll need both 32-bit and 64-bit Oracle clients…
How are date and time values aggregated in SQL? Date and time values are not entirely intuitive to aggregate into averages in T-SQL, although the…
What does it mean by invalid identifier? Invalid identifier means the column name entered is either missing or invalid, this is one of the most…
How does denormalization improve performance? Denormalization can improve performance by: Minimizing the need for joins. Precomputing aggregate values, that is, computing them at data modification…
How do you perform tail-log backup on primary server in case of failover? A tail-log backup is a special type of transaction log backup….Let’s discuss…
What is cross database transaction? A Cross database transaction occurs between 2 or more databases on the same server. It does not require the involvement…
How do I change the default port for SQL Server 1433? Go to Start > programs > Microsoft SQL Server > Configuration Tools > SQL…