|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Stored Procedures are called by the programmer wherever it wants to fire and
the stored procedures used in the database independently.
To use stored procedure you have to make a call to that procedure.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
The global variable @@Version stores the build number of the sqlservr.exe, which is used to determine the service pack installed.
SELECT SERVERPROPERTY('PRODUCTLEVEL')
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Replication is a method of copying data from one database to other database or one server to another .
We have different types replications.
Transactional , Snapshot , Merge , Logshipping and in 2005 one more type is introducde which was called as peer to peer replications.
Transactional Replication In transactional replication data is copied first time as in snapshot replication , but later only the transactions are synchronized rather than replicating the whole database.You can either specify to run continuously or on periodic basis.
Snapshot Replication takes snapshot of one database and moves it to the other database.After initial load data can be refreshed periodically.The only disadvantage of this type of replication is that all data has to copied
each time the table is refreshed.
Merge replication combines data from multiple sources into a single central database.Again as usual the initial
load is like snapshot but later it allows change of data both on subscriber and publisher , later when they come on-line it detects and combines them and updates accordingly.
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Commonly used database maintenance commands are - DBCC CHECKDB, DBCC CHECKTABLE, DBCC CHECKCATALOG, DBCC CHECKALLOC, DBCC SHOWCONTIG,
DBCC SHRINKDATABASE, DBCC SHRINKFILE.
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
RAID stands for Redundant Array of Inexpensive Disks, used to provide fault tolerance to database servers. There are six RAID levels 0 through 5 offering different levels of performance, fault tolerance.
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Active/Active
Here first node will be default and second node will be named instance. Both node will be active.
Move group from cluster administration is possible for both side.
System performance will go down, if both resources are in one node.
Active/Passive
Only one Active node with default instance. No system performance degradation will be there for this
case even if we switchover to the other node. Both have same configuration.
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.