|
|
|
|
|
MS SQL Server Interview Questions / FAQs |
|
|
| How to convert timestamp data to date data (datetime datatype) in SQL Server? |
| The name timestamp is a little misleading. Timestamp data has nothing to do with dates and times and can not be converted to date data. A timestamp is a unique number within the database and is equivalent to a binary(8)/varbinary(8) datatype. A table can have only one timestamp column. Timestamp value of a row changes with every update of the row. To avoid the confusion, SQL Server 2000 introduced a synonym to timestamp, called rowversion. |
|
|
|
|
|
| What is DTC (Distributed Transaction Coordinator) in SQL Server? |
| The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction. |
|
|
|
|
|
| What is DTS (Data Transformation Services) in SQL Server? |
| Microsoft SQL Server 2000 Data Transformation Services (DTS) is a set of graphical tools and programmable objects that lets you extract, transform, and consolidate data from disparate sources into single or multiple destinations. |
|
|
|
|
|
| What is the basic functions for master, msdb, model, tempdb databases? |
The Master database holds information for all databases located on the SQL Server instance and is the glue that holds the engine together. Because SQL Server cannot start without a functioning master database, you must administer this database with care.
The msdb database stores information regarding database backups, SQL Agent information, DTS packages, 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 in the instance. |
|
|
|
|
|
| What are the OS services that the SQL Server installation adds? |
| MS SQL SERVER SERVICE, SQL AGENT SERVICE, DTC (Distribution transac co-ordinator) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|