Useful tips for everyday
How do I add a constraint to a database? The basic syntax of an ALTER TABLE command to ADD PRIMARY KEY constraint to a table…
Why is execution plan important in SQL Server? Execution plans are a very important tool for optimizing query performance. Every DBA needs to know all…
What is a state of a database? Database state, in database technology the set of stored data. Entering, modifying, or deleting information changes the database…
How do I install IBM DB2 Data Studio? Procedure Download IBM Data Studio. Select to download the Data Studio client. When you complete the download,…
What is deadlock issue in SQL Server? SQL Server deadlock is essentially a standoff between two processes that are competing for exclusive access to the…
How do I assign a row number in SQL without Rownum? “generate row number in mysql without rownum” Code Answer set @row_number := 0; SELECT.…
What can I use instead of a cursor? Temporary tables have been in use for a long time and provide an excellent way to replace…
What do I need to define an extension in PostgreSQL? To define an extension, you need at least a script file that contains the SQL…
Why are aggregate functions not allowed in where? You cannot use aggregate functions in a WHERE clause or in a JOIN condition. Whenever an aggregate…
How do I calculate the future interest on a loan? There are two ways to compute this value. Future Value for Simple Interest Formula: FV…