Biggest database size is 30GB No of users 5000 in production.
Normalization usually involves dividing a database into two or more tables and defining relationships between the tables. It is a utility, used to copy the definitions of all objects of a database. Slow bcp – logs each row insert that it makes, used for tables that have one or more indexes or triggers. An index key that includes two or more columns; for example authors(au_lname,au_fname) Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. What’s the different between a primary key and unique key? While an update lock is in place, there can be shared locks thus allowing for higher throughput.
The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships. From a database to an operating system file or from an operating system file to database. Fast bcp – logs only page allocation, copying data into tables without indexes or triggers at fastest speed possible. Both primary key and unique enforce uniqueness of the column on which they are define. The update lock(s) are promoted to exclusive locks once the SQL Server is ready to perform the delete/update.
You’re not concerned with the recovery of recent transactions ( for example, in an early development environment). IDENTITY columns and timestamp columns can’t have defaults bound to them.
Dump transaction with truncate_only to truncate the log your usual method of dumping the transaction log (either the standard dump transaction command or dump transaction with truncate_only) fails because of insufficient log space. See CREATE DEFAULT in books online What is the difference between static and dynamic configuration parameter in Sybase? A concurrency control mechanism that protects the integrity of data and transaction results in a multi-user environment. There are three types of locks: * page locks * table locks * demand locks Page Locks There are three types of page locks: * shared * exclusive * update shared These locks are requested and used by readers of information.
Use no log only when you have totally run out of the log space and can’t run usual dump transaction command. It doesn’t depend on a value in the outer subquery.