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

2 Answers   CSC,

---

Ms sql server index?

0 Answers  

---

Explain throw statement in sql server 2008?

0 Answers  

---

Why use “pivot” in sql server?

0 Answers  

---

How to send email from database?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

What is the purpose of the model database?

0 Answers  

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---

Can XML be used to access data?

2 Answers  

---