Sharepoint - Asp.net - MVC - C# - Sql server - Jquery - Javascript

What is Difference between ER Modeling and Dimensional Modeling? ER modeling is used for normalizing the OLTP database design. Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design. What is Degenerate Dimension Table? If a table contains values, which are neither dimension nor measures, then it is called a degenerate dimension  table. Why is Data Modeling Important? Data modeling is probably the most labor intensive and time consuming part of the development process. The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language, it can be reviewed and verified as correct by the end users. In computer science, data modeling is the process of creating a data model by applying a data model theory to create a data model instance. A data model theory is a formal data model description. In data modeling, we are structur

What is Business Intelligence (BI)? Business Intelligence (BI) refers to technologies, applications and practices for the collection, integration, analysis, and presentation of business information and sometimes to the information itself. The purpose of BI is to support better business decision making. Thus, BI is also described as a decision support system (DSS). BI systems provide historical, current, and predictive views of business operations, most often using data that has been gathered into a data warehouse or a data mart and occasionally working from operational data. What is a Dimension Table? Dimensional table contains textual attributes of measurements stored in the facts tables. Dimensional table is a collection of hierarchies, categories and logic which can be used for user to traverse in hierarchical nodes. What is Dimensional Modeling? Dimensional data model concept involves two types of tables and it is different from the 3rd normal form. This concept uses Facts ta

How to Find Tables without Indexes? Run the following query in the Query Editor. USE < database_name >; GO SELECT SCHEMA_NAME ( schema_id ) AS schema_name , name AS table_name FROM sys.tables WHERE OBJECTPROPERTY ( OBJECT_ID , 'IsIndexed' ) = 0 ORDER BY schema_name , table_name ; GO How to Copy Data from One Table to Another Table? There are multiple ways to do this. 1) INSERT INTO SELECT This method is used when table is already created in the database earlier and data have to be inserted into this table from another table. If columns listed in the INSERT clause and SELECT clause are same, listing them is not required. 2) SELECT INTO This method is used when table is not created earlier and it needs to be created when data from one table must be inserted into a newly created table from another table. The new table is created using the same data types as those in selected columns. ( Read more here ) What is Catalog Views? Catalog views return information