Useful tips for everyday
How is SQL performance measured? SQL Server Execution Times: CPU time = 422 ms, elapsed time = 2296 ms. You can see we now have…
What causes a crashed InnoDB table in MySQL? Force shutdown of MySQL service can end up in Innodb crash. Space issue on the serve can…
Which SQL Server version do I have? The first is by using the functionality in SQL Server Management Studio and right clicking on the instance…
What are the types of relationships in ER diagram? When we design a database, we draw an entity relationship diagram (ERD). Unary (one entity is…
How do you run a temp table in SSIS data flow? Right click the Data Flow task and choose Edit. Drag a OLE DB Source…
How do I enable audit trail? To audit by a registered Oracle ID, do the following: Navigate through Security > Audit Trail > Install and…
Can Db_datareader execute Stored Procedures? db_datareader / db_datawriter allows access only to tables & views, but no to execute a stored procedure; you have to…
What are the settings for streaming replication in PostgreSQL? These settings control the behavior of the built-in streaming replication feature (see Section 26.2.5 ). Servers…
What is a terminator in SQL? A statement terminator is a single character. By default, the SQL and XQuery editor uses a semicolon ( ;…
What is a use case for a join index? JOIN INDEX is a materialized view. Its definition is permanently stored and the data is updated…