Useful tips for everyday
What causes an error in create table as select? Closed 4 years ago. It’s strange or I am new? Here is a simple create table…
What is a bad fragmentation percentage? There’s no hard and fast rule about how fragmented your drive should be before you defrag it. You might…
Why a ternary relationship is not the same as three binary relationships? 2 Answers. Because with 3 binary relationships each involved entity is related separately…
How can I improve my CTE performance? SQL Performance Tips Do not use * with select statement. Use EXISTS instead of IN. Select Appropriate Data…
How does the xmltable function work in PostgreSQL? In the SQL standard, the xmltable function evaluates expressions in the XML Query language, but PostgreSQL allows…
How do I PIVOT multiple columns in SQL Server? 5 Answers. You gotta change the name of columns for next Pivot Statement. You can use…
How do I reverse log shipping in SQL Server? REVERSE LOG SHIPPING Disable the log shipping backup job on the primary server. On the standby…
What do you need to know about GTID replication? The first thing that we need to know is that now Binary Logs and Position are…
How to import a CSV file into MySQL? I need to import a csv file with 20 million rows and 2 columns into a database,…
What happens when you search in a search engine? When you type a query into a search engine, you’re not directly searching the internet for…