What is an indexing technique?

0 Answers  

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

Where the sql logs gets stored? : sql server database administration

0 Answers  

---

Why use update_statistics command in sql server?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

why would you use sql agent? : Sql server database administration

0 Answers  

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

Explain DBCC?

0 Answers   QuestPond,

---

what purpose does the model database serve? : Sql server database administration

0 Answers  

---

Define Unique Key?

0 Answers   HCL,

---