Useful tips for everyday
How do I push a local Postgres database to Heroku? I want to push my local postgresql database to heroku, using heroku pg:push command. The…
How to improve ORDER BY performance in SQL? 25 tips to Improve SQL Query Performance Use EXISTS instead of IN to check existence of data.…
What is RPC completed in SQL Profiler? RPC:Completed means stored proc has completed. It could be that EF executes SQL code dinamically using sp_executesql so…
How do I make NULL values 0 in MySQL? Use IFNULL or COALESCE() function in order to convert MySQL NULL to 0. Insert some records…
How do I select data from a linked server in SQL? 1 Open SQL Server Management Studio, navigate to the Object Explorer pane, and select…
How do I copy a table from one database to another database in SQL Server? Open SQL Server Management Studio. Right-click on the database name,…
How to Monitor database performance? Five Best Practices for Proactive Database Performance Monitoring Monitor Availability and Resource Consumption. This first step of proactive monitoring is…
What is precision and scale for decimal? Precision is the number of digits in a number. Scale is the number of digits to the right…
How do I create a synonym in SQL Server? Using SQL Server Management Studio In Object Explorer, expand the database where you want to create…
When to take backup of Oracle database schema? If user wants to take part of database then that backup is called as incremental backup. The…