Useful tips for everyday
How do I limit characters in a SQL query? Use MySQL’s SUBSTRING function, as described in the documentation. Like: SELECT SUBSTRING(`text`, 1, 100) FROM blog_entry;…
What is row-based replication? Row-based replication Under this method, the binary log stores the record-level changes that occur to database tables on the master server.…
What can I delete from my C drive to free up space? 7 Hacks to Free Up Space on Your Hard Drive Uninstall unnecessary apps…
How can I speed up my UPDATE statement? An update statement is a fully logged operation and thus it will certainly take considerable amount of…
Why is SQL Server 2008 R2 not working? When i try to connect to SQL Server (2008 R2) using Windows authentication: Checking the Windows Application…
How can I speed up SQL Server update query? Here are few tips to SQL Server Optimizing the updates on large data volumes. Removing index…
How do I combine two tables by matching a column in Excel? Combine tables in Excel by column headers On your Excel ribbon, go to…
What does ambiguous column name mean? Run the query below: If you run the above query, you will get this error — “Ambiguous name column”.…
How do I import a CSV file into Oracle 12c? Import CSV file into Oracle table tips Define the empty table. (create table . .…
How do you update a table with a join in Oracle? MERGE into table1 USING table2 ON (table1.id = table2.id) WHEN MATCHED THEN UPDATE SET…