Answer / gunjan sapra

fill factor is a defiened percentage between 0 to 100 in
which we leave exra gaps to accomodate future expansions in
the storage of the futures data.
indexing in sql is same as the index in our books. it helps
us to manage our data more appropriately.it can be done in
two ways namely clustered index and non-clusterd index.
we can create only one clustered index per table and
maximum of 249 non-clustered indexes per table.

How to create stored procedures with parameters in ms sql server?

0 Answers  

---

How many types of local tables are there in sql server?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What are the new features in sql server 2016?

0 Answers  

---

How to add an address record into adventureworkslt?

0 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

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

2 Answers   CSC,

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

0 Answers  

---

Comment,Datatypes are unlimited

0 Answers   IBM,

---

Tell me what is the stuff and how does it differ from the replace function?

0 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

0 Answers  

---

Can a trigger be created on a view?

0 Answers  

---