.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

<< < … 23 24 25 26 27 28 29 30 31 32 33 … > >>   Sort: Rank

Can we suggest locking hints to SQL SERVER
Can we suggest locking hints to SQL SERVER ? We can give locking hints that helps you over ride default decision made by SQL Server. For instance, you can specify the ROWLOCK hint with your UPDATE statement to convince SQL Server to lock each row affected by that data modification. Whether it's prud... 2007-10-25, 5352👍, 0💬

What are the different locks in SQL SERVER
What are the different locks in SQL SERVER ? Depending on the transaction level six types of lock can be acquired on data Intent The intent lock shows the future intention of SQL Server's lock manager to acquire locks on a specific unit of data for a particular transaction. SQL Server uses intent lo... 2007-10-25, 5544👍, 0💬

What are different types of locks in SQL SERVER
What are different transaction levels in SQL SERVER? Transaction Isolation level decides how is one process isolated from other process.Using transaction levels you can implement locking in SQL SERVER. There are four transaction levels in SQL SERVER READ COMMITTED The shared lock is held for the dur... 2007-10-25, 6363👍, 0💬

If locking is not implemented what issues can occur
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you do not implement locking properly in SQL SERVER. Lost Updates Lost updates occur if you let two transactions modify the same data at the same time, and the transaction that completes first is lost. You... 2007-10-25, 7637👍, 0💬

What is the difference between DELETE TABLE and TRUNCATE TABLE commands
What is the difference between DELETE TABLE and TRUNCATE TABLE commands? Following are difference between them ? DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table ... 2007-10-25, 5428👍, 0💬

What is RAID and how does it work
What is RAID and how does it work ? Redundant Array of Independent Disks (RAID) is a term used to describe the technique of improving data availability through the use of arrays of disks and various data-striping methodologies. Disk arrays are groups of disk drives that work together to achieve high... 2007-10-25, 5740👍, 0💬

When does page split occurs ?
What is fillfactor ? The 'fill factor' option specifies how full SQL Server will make each index page. When there is no free space to insert new row on the index page, SQL Server will create new index page and transfer some rows from the previous page to the new one. This operation is called page sp... 2007-10-25, 5563👍, 0💬

What is DTS
What is DTS? DTS is used to pull data from various sources into the star schema. 2007-10-25, 5211👍, 0💬

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, 5431👍, 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, 5125👍, 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, 4965👍, 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, 7672👍, 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, 5415👍, 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, 5173👍, 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, 4675👍, 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, 5154👍, 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, 5295👍, 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, 5408👍, 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, 7611👍, 0💬

What is Maximum Pool Size in ADO.NET Connection String
What is Maximum Pool Size in ADO.NET Connection String? 2007-10-24, 5453👍, 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, 7081👍, 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, 5250👍, 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, 5513👍, 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, 5324👍, 0💬

<< < … 23 24 25 26 27 28 29 30 31 32 33 … > >>   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