Useful tips for everyday
How do I set max memory in SQL Server? Setting a Maximum Memory Limit for a SQL Server Instance. In Enterprise Manager, right-click on the…
How do I delete pgAdmin from my Mac? The easiest way to remove PostgreSQL from Mac Download App Cleaner & Uninstaller and launch it. Confirm…
Where are table valued parameters stored? A table-valued parameter can be in the FROM clause of SELECT INTO or in the INSERT EXEC string or…
How do you create a table that has the same structure or create duplicate table? The first method is called Simple Cloning and as its…
How do I select a column in left join? Just list the columns you want to select as you would in any query: SELECT table1.…
How do I force detach a SQL database? Using SQL Server Management Studio Right-click the database name, point to Tasks, and then click Detach. How…
What is the use of replication slots in Postgres? What are PostgreSQL Replication Slots? A replication slot is a feature in PostgreSQL that ensures that…
Can you connect to MySQL database from Node.js? Let’s test connect.js program. If you see the message “connected to the MySQL server”, then congratulation, you…
How do I reorder data in Excel to match another column? How to quickly sort rows to match another column in Excel? Select a blank…
How many cores does a soft NUMA have? When the detected number of physical cores is more than eight per socket, the SQL Server Database…