What are the different types of replication? Explain. 2008-05-10 04:24:06 The SQL Server 2000-supported replication types
are as follows:· Transactional· Snapshot· MergeSnapshot replication distributes data exactly as it appears at a specific moment in time and does notmonitor for updates to the data. Snapshot replication is best used as a method for replicating data thatchanges infrequently or where the most up-to-date values (low latency) are not a requirement. Whensynchronization occurs, the entire snapshot is generated and sent to Subscribers.Transactional replication, an initial snapshot of data is applied at Subscribers, and then when datamodifications are made at the Publisher, the individual transactions are captured and propagated toSubscribers.Merge replication is the process of distributing data from Publisher to Subscribers, allowing thePublisher Read more:different
What does it mean to have quoted_identifier on? What are the implications of having it off? 2008-05-10 04:22:53 When SET QUOTED_IDENTIFIER is ON, identifiers can be delimited by double quotation marks, andliterals must be delimited by single quotation marks. When SET QUOTED_IDENTIFIER is OFF, identifierscannot be quoted and must follow all Transact-SQL rules for identifiers.
What is the STUFF function and how does it differ from the REPLACE function? 2008-05-10 04:22:15 STUFF function
to overwrite existing characters. Using this syntax, STUFF(string_expression, start,length, replacement_characters), string_expression is the string that will have characters substituted,start is the starting position, length is the number of characters in the string that are substituted, andreplacement_characters are the new characters interjected into the string.REPLACE function to replace existing characters of all occurance. Using this syntaxREPLACE(string_expression, search_string, replacement_string), where every incidence ofsearch_string found in the string_expression will be replaced with replacement_string. Read more:differ
How to rebuild Master Database? 2008-05-10 04:21:29 Shutdown Microsoft SQL Server 2000, and then run Rebuildm.exe. This is located in the ProgramFiles\Microsoft SQL Server\80\Tools\Binn directory.In the Rebuild Master
dialog box, click Browse.In the Browse for Folder dialog box, select the \Data folder on the SQL Server 2000 compact disc or inthe shared network directory from which SQL Server 2000 was installed, and then click OK.Click Settings. In the Collation Settings dialog box, verify or change settings used for the masterdatabase and all other databases.Initially, the default collation settings are shown, but these may not match the collation selected duringsetup. You can select the same settings used during setup or select new collation settings. When done,click OK.In the Rebuild Master dialog box, click Rebuild to start the process. Read more:Database
What is the basic functions for master, msdb, model, tempdb databases? 2008-05-10 04:20:57 The Master database holds information for all databases located on the SQL Server instance and is theglue that holds the engine together. Because SQL Server cannot start without a functioning masterdatabase, you must administer this database with care.The msdb database stores information regarding database backups, SQL Agent information, DTSpackages, SQL Server jobs, and some replication information such as for log shipping.The tempdb holds temporary objects such as global and local temporary tables and stored procedures.The model
is essentially a template database used in the creation of any new user database created inthe instance.
What are primary keys and foreign keys? 2008-05-10 04:20:35 Primary keys are the unique identifiers for each row. They must contain unique values and cannot benull. Due to their importance in relational databases, Primary keys are the most fundamental of all keysand constraints. A table can have only one Primary key.Foreign keys are both a method of ensuring data integrity and a manifestation of the relationshipbetween tables.
What is data integrity? Explain constraints? 2008-05-10 04:20:04 Data integrity is an important feature in SQL Server. When used properly, it ensures that data isaccurate, correct, and valid. It also acts as a trap for otherwise undetectable bugs within applications.A PRIMARY KEY constraint is a unique identifier for a row within a database table. Every table shouldhave a primary key constraint to uniquely identify each row and only one primary key constraint can becreated for each table. The primary key constraints are used to enforce entity integrity.A UNIQUE constraint enforces the uniqueness of the values in a set of columns, so no duplicate valuesare entered. The unique key constraints are used to enforce entity integrity as the primary keyconstraints.A FOREIGN KEY constraint prevents any actions that would destroy links between tables with thecorr
What are the properties of the Relational tables? 2008-05-10 04:19:12 Relational tables have six properties:· Values are atomic.· Column values are of the same kind.· Each row is unique.· The sequence of columns is insignificant.· The sequence of rows is insignificant.· Each column must have a unique name.
Recommend Site To A Friend
