Answer Posted / jyoti

CREATE TABLE #CustDetails
(
CustID INT IDENTITY(1,1),
CustName VARCHAR(10),
City VARCHAR(10)
)

INSERT INTO #CustDetails
SELECT 'A1','Pune' UNION ALL
SELECT 'A2','Pune' UNION ALL
SELECT 'A3','Pune' UNION ALL
SELECT 'A4','Pune' UNION ALL
SELECT 'A5','Pune' UNION ALL
SELECT 'A6','Pune' UNION ALL
SELECT 'B1','Delhi' UNION ALL
SELECT 'B2','Delhi' UNION ALL
SELECT 'B3','Delhi' UNION ALL
SELECT 'B4','Delhi' UNION ALL
SELECT 'B5','Delhi' UNION ALL
SELECT 'B6','Delhi' UNION ALL
SELECT 'B7','Delhi' UNION ALL
SELECT 'B8','Delhi' UNION ALL
SELECT 'C1','Mumbai' UNION ALL
SELECT 'C2','Mumbai' UNION ALL
SELECT 'C3','Mumbai' UNION ALL
SELECT 'C4','Mumbai' UNION ALL
SELECT 'C5','Mumbai'

SELECT
ID,CustName,City
FROM
(
SELECT
ROW_NUMBER() OVER (PARTITION BY CITY ORDER
BY CustID DESC) ID,CustName,City
FROM
#CustDetails AS CD1
) A
WHERE A.ID < 3

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

948

---

What are relationships and mention different types of relationships in the dbms

962

---

What is dbcc?

1135

---

Explain index in sql server?

1012

---

What is factless fact table? : sql server analysis services, ssas

1028

---

How to create a trigger for insert only?

1038

---

Is it possible in sql table to have more than one foreign key?

1033

---

What happens if null values are involved in arithmetic operations?

1011

---

Explain about link server in sql server?

1056

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1161

---

Define Business Edition in SQL Azure?

100

---

Does a sql server 2005 select statement require a from?

1018

---

How will you optimize a stored procedure optimization?

1040

---

What is the full form of dql?

981

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6884

---