Useful tips for everyday
How can we get the number of records or rows in a table using MySQL? We can get the number of rows or records present…
What is the length of text in PostgreSQL? What is PostgreSQL Text datatype? In PostgreSQL, the text data type is used to keep the character…
How to SELECT DISTINCT values from query results in PostgreSQL? DISTINCT is used to remove duplicate rows from the SELECT query and only display one…
How long does transactional replication take in SQL Server? Monitoring SQL Server Transactional Replication. It is necessary to implement a latency report to monitor and…
How do you investigate long running queries in SQL? How to find Longest running queries in SQL Server SELECT DISTINCT TOP 20. est.TEXT AS QUERY…
How do you UPDATE multiple records at time? There are a couple of ways to do it. INSERT INTO students (id, score1, score2) VALUES (1,…
What are included columns? Covering Index Indexes with included columns provide the greatest benefit when covering the query. This means that the index includes all…
What are the permissions to modify SQL Agent jobs? It includes all the permissions of SQLAgentUserRole and SQLAgentReaderRole. Members of this role can also view…
How to monitor if MySQL binlog files get corrupt? Back on Dec 26, 2011, I wrote about a based-64 number that sits at the top…
What does restoring database backup mean? Restoring is the process of copying data from a backup and applying logged transactions to the data. Restore is…