Useful tips for everyday
How do I fix error 1067 the process terminated unexpectedly? Error 1067, The process terminated unexpectedly Refresh the potentially corrupted Service settings in Registry. Run…
How do I list my Backupset in RMAN? RMAN List Command Database. The LIST command allows the backup data to be listed in the RMAN…
What should be first need when design a database? The design process Determine the purpose of your database. This helps prepare you for the remaining…
How can we avoid spurious tuples? To prevent spurious tuples, avoid joining relations that consist of matching attributes that are not (foreign key, primary key)…
How do I combine data in one row? Combine text from two or more cells into one cell Select the cell where you want to…
How do I stop a table from dropping in SQL? To prevent dropping tables, you can use the a DDL trigger. PRINT ‘You must disable…
What is total server memory in SQL Server? Total Server Memory (KB) “Specifies the amount of memory the server has committed using the memory manager.”…
Can not start SQL Server? Reason # 2:Startup parameters have incorrect file path locations. This is another common cause of SQL Server Service startup failure.…
How do I fill a date gap in SQL? Filling the Date Gap Demo for SQL Server Step 1 –Set up the Virtual Date Common…
What is the degree of ternary relationship? A ternary relationship exists when exactly three entity type participates. When such a relationship is present we say…