How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

What are different type of Collation Sensitivity?

0 Answers  

---

Is it ok to shrink transaction log?

0 Answers  

---

What are the difference between clustered and a non-clustered index?

0 Answers  

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

How use inner join in sql server?

0 Answers  

---

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

---

How column data types are determined in a view?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

Explain an automatic checkpoint

0 Answers  

---