1 2 >   Sort: Date

If we have multiple AFTER Triggers on table how can we define the sequence of the triggers
If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ? If a table has multiple AFTER triggers, then you can specify which trigger should be executed first and which trigger should be executed last using the stored procedure sp_settriggerorder. All the other trig...
2007-10-25, 6937👍, 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, 6728👍, 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, 6718👍, 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, 6593👍, 0💬

What is the purpose of Replication
What is the purpose of Replication ? Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber. Publisher Database server that makes data available for replication is called as Publisher. Subscriber Database Serve...
2007-10-25, 6399👍, 0💬

How can you raise custom errors from stored procedure
How can you raise custom errors from stored procedure ? The RAISERROR statement is used to produce an ad hoc error message or to retrieve a custom message that is stored in the sysmessages table. You can use this statement with the error handling code presented in the previous section to implement c...
2007-10-25, 6182👍, 0💬

What is BCP utility in SQL SERVER
What is BCP utility in SQL SERVER ? BCP (Bulk Copy Program) is a command line utility by which you can import and export large amounts of data in and out of SQL SERVER database. Below is a sample which shows BCP in action.
2007-10-25, 5582👍, 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, 5526👍, 0💬

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Following are some major differences between a stored procedure and user defined functions: UDF can be executed using the “SELECT” clause while SP’s can not be. UDF can not be used in XML FOR clause but SP’s can b...
2007-10-25, 5305👍, 0💬

What is DBCC
What is DBCC? DBCC (Database Consistency Checker Commands) is used to check logical and physical consistency of database structure.DBCC statements can fix and detect problems.They are grouped in to four categories Maintenance commands like DBCC DBREINDEX , DBCC DBREPAR etc , they are mainly used for...
2007-10-25, 5266👍, 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, 5077👍, 0💬

What is SQl injection
What is SQl injection ? It is a Form of attack on a database-driven Web site in which the attacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a databas...
2007-10-25, 5063👍, 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, 4949👍, 0💬

What are the different types of replication supported by SQL SERVER
What are the different types of replication supported by SQL SERVER ? There are three types of replication supported by SQL SERVER Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The ...
2007-10-25, 4930👍, 0💬

What is ACID fundamental? What are transactions in SQL SERVER
What is ACID fundamental? What are transactions in SQL SERVER ? A transaction is a sequence of operations performed as a single logical unit of work. A logical unit of work must exhibit four properties, called the ACID (Atomicity, Consistency, Isolation, and Durability) properties, to qualify as a t...
2007-10-25, 4912👍, 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, 4860👍, 0💬

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, 4849👍, 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, 4844👍, 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, 4758👍, 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, 4752👍, 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, 4744👍, 0💬

What are the different types of triggers in SQl SERVER 2000
What are the different types of triggers in SQl SERVER 2000 ? There are two types of triggers : INSTEAD OF triggers INSTEAD OF triggers fire in place of the triggering action. For example, if an INSTEAD OF UPDATE trigger exists on the Sales table and an UPDATE statement is executed against the Sales...
2007-10-25, 4697👍, 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, 4687👍, 0💬

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? You can use Having Clause with the GROUP BY function in a query and WHERE Clause is applied to each row before they are part of the GROUP BY function in a query.
2007-10-25, 4670👍, 0💬

1 2 >   Sort: Date