Useful tips for everyday
How do I join a derived table? The join is specified by the where clause. The two tables joined are dt_c, which is a SQL-derived…
How to search and replace fields in MySQL? I.e. search for foo and replace with bar so a record with a field with the value…
When do you use update lock in SQL Server? When two transactions are waiting on each other to convert Shared locks on resources to Exclusive…
How do I change from SQL Enterprise to standard? Downgrade SQL Server Enterprise to Standard Edition Navigate to the Control Panel and choose Uninstall a…
How replication happens in MongoDB? Replication allows you to increase data availability by creating multiple copies of your data across servers. With MongoDB, replication is…
How do I run a DDL script in PostgreSQL? To run DDL in the form of an SQL script, you should use psql , the…
How do I check if data exists in a table? To test whether a row exists in a MySQL table or not, use exists condition.…
What is stolen pages in SQL Server? ‘Stolen Pages’ indicates internal memory pressure. First find out who stole the pages! select type, name, sum((single_pages_kb*1024)/8192) as…
How MySQL stores data on disk? Basically mySQL stores data in files in your hard disk. It stores the files in a specific directory that…
How do I fix a missing package? How to Find and Fix Broken Packages Open your terminal by pressing Ctrl + Alt + T on…