Useful tips for everyday
How to grant execute to all stored procedures in SQL? SQL Server 2005 introduced the ability to grant database execute permissions to a database principle,…
How do I enable access control is not enabled for the database? Make sure the user starting the process has permissions and that the directories…
How can I find the difference between two dates in a month? Use the DATEDIF function when you want to calculate the difference between two…
What is the use of relational calculus in DBMS? The relational calculus consists of two calculi, the tuple relational calculus and the domain relational calculus,…
How do I enable slow queries in MySQL? To enable the slow query log, type the following command at the mysql> prompt: SET GLOBAL slow_query_log…
What does the select statement allow you to do? The SQL SELECT statement returns a result set of records, from one or more tables. A…
Is the auto update statistics async option disabled? This option is set database by database and the default setting for this option is disabled. When…
How do you make a summary table? Here are the steps they go through. Getting Started – Copy the Data. Your First Summary Table. Add…
How do I uninstall Postgres on Mac? To uninstall PostgreSQL on a Mac system, assume the identity of an operating system superuser, and navigate into…
What is difference between data mart and data warehouse? Both Data Warehouse and Data Mart are used for store the data. The main difference between…