Answer / Ambesh Kumar Bhatt

A Primary Key is a special type of constraint that uniquely identifies each record in a table. An Index is a database object that improves the performance of queries by allowing SQL Server to find and retrieve rows more quickly.

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

---

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.

6 Answers   IBM,

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1 Answers  

---

What does truncate do?

1 Answers  

---

What are page splits? : SQL Server Architecture

1 Answers  

---

how can i store resumes in database?

3 Answers   HCL,

---

How many partitions a clustered index has by default in sql server 2012?

1 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,

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

What is the syntax for encrypting a column in SQL Server?

1 Answers   MindCracker,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---