Useful tips for everyday
What is dimensional hierarchy? Dimension hierarchies define structural and mathematical relationships, and consolidations between members in the database. Relationships are represented graphically in a collapsible…
Which is an example of an outer join in SQL? This article will provide a full overview, with examples of the SQL Outer join, including…
What is a business rule in a database? A business rule is a statement that imposes some form of constraint on a specific aspect of…
What are the nodes in a MySQL Cluster? A MySQL Cluster consists of one or more management nodes ( ndb_mgmd) that store the cluster’s configuration…
Can we use datediff in where clause? The DATEDIFF function can also be used in a WHERE clause as well as ORDER BY and HAVING…
How do I know if a given query uses an index or not? In SQL Management Studio, just type in the query, and hit Control-L…
How to troubleshoot service broker in SQL Server? These queries should be issued in both the initiator and target databases to validate that the objects…
How can I get all column names from a table in mysql? Get column names from a table using INFORMATION SCHEMA SELECT COLUMN_NAME. FROM INFORMATION_SCHEMA.…
What does check integrity mean? Definition. Integrity checking is. [t]he testing of programs to verify the soundness of a software product at each phase of…
How do you change the datatype of a primary key in a column? You can’t change primary key column,unless you drop it.. Any operations to…