Useful tips for everyday
What is connection in PostgreSQL? 1) Connect to PostgreSQL database server using psql It allows you to interact with the PostgreSQL database server such as…
How can I enable MySQL strict mode? For Windows, Go to C:\Program Files\MariaDB XX. X\data. Open the my. ini file. *On the line with “sql_mode”,…
What is PowerShell used for in SQL Server? PowerShell is the preferred scripting tool used by Windows and Active Directory administrators. It can also be…
Can you merge two tables in Word? Hover your pointer over the table you would like to merge until the table’s handle (the plus sign)…
Why do we need index in database? Indexes are used to quickly locate data without having to search every row in a database table every…
What is open transaction in SQL Server? DBCC OPENTRAN helps to identify active transactions that may be preventing log truncation. Results are displayed only if…
When was data last updated in a table? For example, create a table to store object_id and last seek/scan/update. Every n minutes, take a snapshot…
Is SQL a data analytics tool? We query data from a relational database with the select statement of SQL. The select statement is highly versatile…
How do I manually Uninstall an instance of SQL Server 2012? To begin the removal process, navigate to the Control Panel and then select Programs…
How are statistics collected in Oracle Enterprise Manager? Although Oracle Enterprise Manager, Statspack and BSTAT/ESTAT, and the V$views have different interfaces (GUI, command line, SQL),…