Useful tips for everyday
Is temp tablespace common in RAC? Answer: Yes, in Real Application Clusters (RAC), a common TEMP tablespace is shared between nodes in a shared ASM…
Does PG restore overwrite? Restoring the data from pg_dump doesn’t overwrite the data but it appends the data to the original database. Does Pg_restore delete…
Does SQL Server service account needs to be local administrator? For improved security Microsoft recommends the SQL Server Agent service account should not be a…
How to create stored procedure with multiple parameters? Create SQL Server Stored Procedure with Multiple Parameters Setting up multiple parameters is very easy to do.…
How do I enable memory optimized filegroup? To create a database with a memory-optimized data filegroup Right-click Databases, and then click New Database. To add…
How do I count the number of specific values in a column in Excel? Count cells equal to Generic formula. =COUNTIF(range,value) To count the number…
What happens when SQL Server Evaluation expired? The SQL Server evaluation edition is free for 180 days but when the evaluation period has expired, the…
How do I change my browser on pgAdmin? Run your pgadmin in default browser. right click the icon in the Windows System Tray and select…
How is the sum of all calculated columms calculated on a joined child table? The child rows have a total price which is calculated by…
How do I get a job in SQL Server Agent? To view job activity Expand SQL Server Agent. Right-click Job Activity Monitor and click View…