What is index?

1 Answers   Cap Gemini,

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

What are the disadvantages of indexes?

0 Answers  

---

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

0 Answers  

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

---

What is normalization process?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---