Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

---

How to maintain a fill factor in existing indexes?

0 Answers  

---

what are default? Is there a column to which a default cant be bound?

1 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

How can you fetch alternate records from a table?

0 Answers  

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

How to write a query with a left outer join in ms sql server?

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

What is difference between view and materialized view?

0 Answers  

---