Useful tips for everyday
How do I find the columns of a table in PostgreSQL? Execute the a SQL statement in ‘psql’ to get the column names of a…
How do I expose SQL Server Internet? Making SQL Server Accessible Over Internet System should have static IP where SQL server is installed. Open SSMS,…
How downgrade PostgreSQL brew? 1. Remove all PostgreSQL version installed Check running version brew services list then stop them brew services stop postgresql . Delete…
How do I add values to an existing table? SQL INSERT statement – insert one row into a table First, the table, which you want…
How do you improve SQL performance in joins? It’s vital you optimize your queries for minimum impact on database performance. Define business requirements first. SELECT…
How to get a result from a result set in Java? This cursor is a pointer that points to one row of data in the…
What does sys.dm _ exec _ connections ( Transact-SQL ) do? Applies to: SQL Server (all supported versions) Azure SQL Database Azure Synapse Analytics Returns…
What happens when I upgrade MongoDB to 3.2? MongoDB 3.2 generates core dumps on some mongod failures. For production environments, you may prefer to turn…
How many columns should a Postgres table have? 1600 columns PostgreSQL tables are hard-limited to a maximum of 1600 columns. How many columns can an…
How does right joins work in PHP MySQL? Right joins work opposite to left joins. That is, priority is given to right table and fetches…