Useful tips for everyday
What is difference between SYS and SYSTEM in Oracle? An administrator account is any Oracle user account with either the SYSDBA privilege or the DBA…
How do I create a primary key in a table? Creating a primary key in an existing table requires ALTER permission on the table. In…
What is database file size? Go Up to Database Files. InterBase database file size is the product of the number of database pages times the…
Is MySQL5.6 still supported? MySQL 5.6 is covered under Oracle Lifetime Sustaining Support. Per Oracle’s Lifetime Support policy, as of February 1, 2021, MySQL 5.6…
How do I make MySQL secure against attackers? 2.3 Making MySQL Secure Against Attackers Require all MySQL accounts to have a password. Make sure that…
How to define granularity within a measure group? The attribute that is specified as the granularity attribute effectively becomes the key attribute within the measure…
Can you make a PivotTable from multiple tables? You can import multiple tables at the same time. You can add these tables to the Data…
What is the quickest way to create a fact table? To create a Fact table, right click the ‘Fact Tables’ folder (or one of its…
How do I get my DB back? Expand Databases, and either select a user database or expand System Databases and select a system database. Right-click…
How do I write a query in Microsoft SQL Server? Create a database Right-click your server instance in Object Explorer, and then select New Query:…