Useful tips for everyday
How to restart an interrupted SQL Server database restore? The RESTORE DATABASE…WITH RESTART command is a very useful command which is available in SQL Server…
Can we create index on timestamp? Indexes work with timestamp columns. Should enable an index-only scan. Avoiding the table should make the query faster. Can…
What is the value of an attribute in EAV? The value is the value of that attribute, for example our product might have an attribute…
How do I join the same table twice in mysql? To perform a self join, you must use table aliases to not repeat the same…
What is the difference between select count (*) and select count 1? How do you specify difference between count(*) and count(1) in a select statement?…
How to filter data between specified dates is a? The column containing the date is in string format (yyyy-mm-dd). I can use month () and…
Where are the generated columns stored in PostgreSQL? Defined in the SQL standard, this type of column computes its value from the contents of other…
What happens if we shrink data file in SQL Server? Shrinking data files recovers space by moving pages of data from the end of the…
How do I take SCN based incremental backup? Refreshing a Standby Database With INCREMENTAL FROM SCN Backups: Example Step 1: Create the Incremental Backup. Step…
Can we change username in Oracle? There appears to be no rename command for an Oracle user. Answer: There is no supported method for renaming…