Useful tips for everyday
How do I show database schema? To show the schema, we can use the DESC command. This gives the description about the table structure. How…
How do I get SQL Server out of restoring state? Right Click database go to Tasks –> Restore –> Transaction logs In the transactions files…
When to use cross join or inner join in MariaDB? In MariaDB, CROSS JOIN is a syntactic equivalent to INNER JOIN (they can replace each…
How do I drop multiple users in SQL? Drop more than one user You can use the DROP USER statement to drop multiple users by…
How do I fix mysql too many connections? Solve a MySQL/MariaDB “Too many connections” error Choose a new maximum number of connections. Change max_connections. Show…
How do you use UNIONs with different number of columns? You would want to select columns as NULL to take up for the empty space…
When can a rollback occur in a transaction? Rolls back an explicit or implicit transaction to the beginning of the transaction, or to a savepoint…
How does SQL Server MDS add-in work for Excel? Master Data Services Add-in for Microsoft Excel. With the SQL Server Master Data Services Add-in for…
When do you need to query multiple ranges? I commonly have to query an extremely large table for multiple variables with many conditions per variable.…
What is the advantage of using a temporary table? Temporary tables behave just like normal ones; you can sort, filter and join them as if…