May 30, 2013 at 10:53 pm
Hi friends,
Recently i faced an interview... i need answers for questions which i am not comfortable in delivering.
1. difference between SQL 2008 and 2008 R2
2. what is virtual memory
3. why we need MSTDC
4. what tranactions involved in MSTDC
4. what is ITIL
5. what is Change Management
6. what is Incident Management
May 31, 2013 at 1:06 am
Hi,
Diff b/w SQL server 2008 and Sql server 2008 R2 as below :
2008 :
1. added new data type Date, time , Geospatial and timestamp with internal time zone
2. Reporting service no longer require IIS as it makes direct call to HTTP.SYS
2008 R2 as added new feature :
1. Power Pivot for share point
2. Power pivot for excel
3. Multi - server administration and data tier application
4. Master data services
5. Connecting to the database engine using extended protection.
MSDTC adn tranactions :
MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. As the name says, MSDTC is a Windows service providing transaction infrastructure for distributed systems. In this case, a transaction means a general way of structuring the interactions between autonomous agents in a distributed system. Each transaction is a state transformation with four key properties - the ACID properties: Atomic (all or nothing), Consistent (legal), Isolated (independent of concurrent transactions) and Durable (once it happens, it cannot be abrogated). There are different techniques that implement the ACID properties but the most known one is two-phase commit.
ITIL: its a certification which is very much use in Europe to work in support project
Regards,
Anshuman Saini
May 31, 2013 at 1:14 am
m.rajesh.uk (5/30/2013)
Hi friends,Recently i faced an interview... i need answers for questions which i am not comfortable in delivering.
1. difference between SQL 2008 and 2008 R2
2. what is virtual memory
3. why we need MSTDC
4. what tranactions involved in MSTDC
4. what is ITIL
5. what is Change Management
6. what is Incident Management
I am not sure if you will get a complete answer to these questions in a forum thread like this.
You will get lots of articles on these topics if you Google. Please check some of those articles and come back with specific questions if you still have some doubts.
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply