Useful tips for everyday
What is deterministic and non deterministic function in Oracle? A deterministic function always returns the same results if given the same input values. A nondeterministic…
How do I fix tempdb contention? Increase the number of data files in tempdb to maximize disk bandwidth and reduce contention in allocation structures. As…
How do I know if committed snapshot is read? To check the current state of Read-Committed Snapshot, open a query window and execute the following…
How do I pull data from another table in SQL? In SQL, to fetch data from multiple tables, the join operator is used. The join…
What is relational algebra queries? Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as…
What is the format for entering date values in a table? Overview of date and time formats The dates appear as, mm/dd/yyyy in the U.S.…
Where is Saturday and Sunday in MySQL? Use SET DATEFIRST 7 to ensure DATEPART(DW.) returns 1 for Sunday and 7 for Saturday. How do I…
How do I install SQL Server Express 2012? Installing SQL Server 2012 Express Login to your Windows server with the administrator user. Double click the…
What is table lock option? Because the option is part of the OLE DB destination task, the “Table Lock” option indicates whether the database engine…
What is Oracle hierarchical query? Description of “Figure 9-1 Hierarchical Queries” To find the children of a parent row, Oracle evaluates the PRIOR expression of…