how would you troubleshoot blocking? : Sql server database administration

0 Answers  

---

What are indexes? When do you need to create Indexes?

4 Answers   CarrizalSoft Technologies, HP,

---

What are the properties of the relational tables?

0 Answers  

---

What is update locks?

0 Answers  

---

What is an identity?

0 Answers  

---

What is a join in sql? What are the types of joins?

0 Answers  

---

How many columns can we include on clustered index ?

0 Answers  

---

How many types of stored procedures are there in sql server?

0 Answers  

---

What is RAID? What are the different types of RAID configurations?

0 Answers   Flextronics,

---

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  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

---