.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 94 95 96 97 98 99 100 101 102 103 104 … > >>   Sort: Rank

Can you explain the star schema for OLAP
What are fact tables and dimension tables in OLAP ? The dimensions and measures are physically represented by a star schema. Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key rel... 2007-10-25, 5549👍, 0💬

What are levels in dimensions
What are levels in dimensions ? Dimensions are arranged in hierarchical levels, with unique positions within each level. For example, a time dimension may have four levels, such as Year, Quarter, Month, and Day. Or the dimension might have only three levels, for example, Year, Week, and Day. The val... 2007-10-25, 5210👍, 0💬

What are dimensions in OLAP
What are dimensions in OLAP ? Dimensions are the categories of data analysis. For example, in a revenue report by month by sales region, the two dimensions needed are time and sales region. Typical dimensions include product, time, and region. 2007-10-25, 5028👍, 0💬

What is a measure in OLAP
What is a measure in OLAP ? Measures are the key performance indicator that you want to evaluate. To determine which of the numbers in the data might be measures. A rule of thumb is: If a number makes sense when it is aggregated, then it is a measure. 2007-10-25, 7760👍, 0💬

What is the use of OLAP
What is the use of OLAP ? OLAP is useful because it provides fast and interactive access to aggregated data and the ability to drill down to detail. 2007-10-25, 5484👍, 0💬

How can you increase SQL performance
How can you increase SQL performance ? Following are tips which will increase your SQl performance Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-on... 2007-10-25, 5284👍, 0💬

What are indexes? What is the difference between stered and nonclustered indexes
What are indexes? What is the difference between clustered and nonclustered indexes? Indexes in SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quickly. There are clustered and nonclustered indexes. A clustered index is a special type of index that reorders the... 2007-10-25, 4741👍, 0💬

What are the different types of joins? What is the difference between them
What are the different types of joins? What is the difference between them ? INNER JOIN Inner join shows matches only when they exist in both tables.Example, in the below SQL there are two tables Customers and Orders and the inner join in made on Customers Customerid and Orders Customerid.So this SQ... 2007-10-25, 5252👍, 0💬

What is a candidate key
What is a candidate key ? A table may have more than one combination of columns that could uniquely identify the rows in a table; each combination is a candidate key. During database design you can pick up one of the candidate keys to be the primary key. For example, in the supplier table supplierid... 2007-10-25, 5368👍, 0💬

What is denormalization
What is denormalization ? Denormalization is the process of putting one fact in numerous places (its vice-versa of normalization).Only one valid reason exists for denormalizing a relational design - to enhance performance.The sacrifice to performance is that you increase redundancy in database. 2007-10-25, 5467👍, 0💬

What is normalization? What are different types of normalization
What is normalization? What are different types of normalization? It is set of rules that have been established to aid in the design of tables that are meant to be connected through relationships. This set of rules is known as Normalization. Benefits of normalizing your database will include: 1. Avo... 2007-10-25, 7750👍, 0💬

What is Maximum Pool Size in ADO.NET Connection String
What is Maximum Pool Size in ADO.NET Connection String? 2007-10-24, 5515👍, 0💬

Explain in detail the fundamental of connection pooling
Explain in detail the fundamental of connection pooling? When a connection is opened first time a connection pool is created and is based on the exact match of the connection string given to create the connection object. Connection pooling only works if the connection string is the same. If the conn... 2007-10-24, 7198👍, 0💬

Can you explain the difference between an ADO.NET Dataset and an ADO Recordset
Can you explain the difference between an ADO.NET Dataset and an ADO Recordset? There two main basic differences between recordset and dataset ? With dataset you an retrieve data from two databases like oracle and sql server and merge them in one dataset , with recordset this is not possible ? All r... 2007-10-24, 5349👍, 0💬

What is difference between Dataset. clone and Dataset.copy
What is difference between Dataset. clone and Dataset. copy ? Clone: - It only copies structure, does not copy data. Copy: - Copies both structure and data. 2007-10-24, 5578👍, 0💬

How can we perform transactions in .NET
How can we perform transactions in .NET? The most common sequence of steps that would be performed while developing a transactional application is as follows: ? Open a database connection using the Open method of the connection object. ? Begin a transaction using the Begin Transaction method of the ... 2007-10-24, 5405👍, 0💬

How many ways are there to implement locking in ADO.NET
How many ways are there to implement locking in ADO.NET ? Following are the ways to implement locking using ADO.NET 1. When we call gUpdateh method of DataAdapter it handles locking internally. If the DataSet values are not matching with current data in Database it raises concurrency exception err... 2007-10-24, 6091👍, 0💬

What’s difference between “Optimistic” and “Pessimistic” locking
What’s difference between “Optimistic” and “Pessimistic” locking ? In pessimistic locking when user wants to update data it locks the record and till then no one can update data. Other user’s can only view the data when there is pessimistic locking. In optimistic locking multiple users can open th... 2007-10-24, 5377👍, 0💬

What is the use of CommandBuilder
What is the use of CommandBuilder ? CommandBuilder builds “Parameter” objects automatically. Below is a simple code which uses commandbuilder to load its parameter objects. Dim pobjCommandBuilder As New OleDbCommandBuilder(pobjDataAd apter)pobjCommandBuilder.DeriveParam eters(pobjCommand)Be careful ... 2007-10-24, 5352👍, 0💬

How can we add relation’s between table in a DataSet
How can we add relation’s between table in a DataSet ? Dim objRelation As DataRelation objRelation=New DataRelation("CustomerAddresse s",objDataSet.Tables("Customer ").Columns("Custid"),objDataSet.Tables("Addresses" ).Columns("Custid_fk"))objDataSet.Relations.Add(objRe lation)Relations can be added b... 2007-10-24, 5187👍, 0💬

How can we load multiple tables in a DataSet
How can we load multiple tables in a DataSet ? objCommand.CommandText = "Table1" objDataAdapter.Fill(objDataSet ,"Table1") objCommand.CommandText = "Table2" objDataAdapter.Fill(objDataSet ,"Table2") Above is a sample code which shows how to load multiple “DataTable” objects in one “DataSet” object.... 2007-10-24, 5020👍, 0💬

Why is DataSet slower than DataReader
What is the difference between “DataSet” and “DataReader” ? Following are the major differences between “DataSet” and “DataReader” ? “DataSet” is a disconnected architecture, while “DataReader” has live connection while reading data. If we want to cache data and pass to a different tier “DataS... 2007-10-24, 5235👍, 0💬

What is basic use of “DataView”
What is basic use of “DataView” ? “DataView” represents a complete table or can be small section of rows depending on some criteria. It is best used for sorting and finding data with in “datatable”. Dataview has the following method’s Find It takes a array of values and returns the index of the r... 2007-10-24, 5934👍, 0💬

How can we add/remove row’s in “DataTable” object of “DataSet”
How can we add/remove row’s in “DataTable” object of “DataSet” ? “Datatable” provides “NewRow” method to add new row to “DataTable”. “DataTable” has “DataRowCollection” object which has all rows in a “DataTable” object. Following are the methods provided by “DataRowCollection” object Add Ad... 2007-10-24, 5391👍, 0💬

<< < … 94 95 96 97 98 99 100 101 102 103 104 … > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML