Useful tips for everyday
Where is postgres HBA file? The standard location is pg_hba. conf within the data_directory of the database (which could be in /home , /var/lib/pgsql ,…
Is parameter sniffing bad? Parameter sniffing is only bad when your data values are unevenly distributed and cached query plans are not optimal for all…
Should I use VARCHAR Max? If you are unsure about your data length and your database is not heavily used you should be fine with…
How do I run a command on a different server? Run command on remote server via ssh If you need to run a command or…
What is the function of the Postgres FDW module? The postgres_fdw module provides the foreign-data wrapper postgres_fdw, which can be used to access data stored…
How do I reduce memory grants in SQL Server? Summary of Ways to Deal with Large Grants: Re-write queries. Use Resource Governor. Find appropriate indexes…
How do I fix ORA 12514 TNS listener does not currently know of service requested in connect descriptor? Check that the SERVICE_NAME parameter in the…
Why is MySQL server unable to connect to SQL Server instance? Open mysql server configuration manager. Click SQL server services, on the right side choose…
What is the cost of joining R and S using a block nested loops join? Answer: The basic idea of nested-loop join is to do…
How do I stop a SQL Server page from splitting? We can reduce page splits by keeping some room in the data pages by setting…