Useful tips for everyday
How do you failover a cluster in SQL Server? Enable the Failover Clustering feature in both the SQL nodes. Confirm the failover cluster installation for…
How many concurrent queries can MySQL handle? It then grows to 70 microseconds for 128 clients, 140 microseconds for 256 clients, and 300 microseconds for…
How to sum a column of numbers in a query? You can sum a column of numbers in a query by using a type of…
Can a column have multiple foreign keys? Foreign Key Columns A single column can have multiple foreign key constraints. For an example, see Add multiple…
Which is better SQL Server or PostgreSQL? But when it comes to different features PostgreSQL is always at the upper hand. It is an advanced…
What are the advantages and disadvantages of using triggers in a database? Pros and Cons of SQL Server Triggers Triggers are easy to code. Triggers…
How to change the user password in PostgreSQL? Changing the Password. With a connection now established to Postgres at the psql prompt, issue the ALTER…
How do I select two distinct columns? Select with distinct on all columns of the first query. Select with distinct on multiple columns and order…
How to check if a stored procedure is still running in SQL Server? How to check if a stored procedure or query is still running…
What is a replication slot? What are replication slots? Streaming replication slots are a new facility introduced in PostgreSQL 9.4. They are a persistent record…