one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

1 Answers   Cognizant,

---

What is difference between count (*) and count 1?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

What is difference between clustered and non clustered index?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

Explain differentiate between a having clause and a where clause?

0 Answers  

---

Is candidate a key?

0 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

Explain unique key in sql server?

0 Answers  

---

What is the maximum length of an alert name?

0 Answers  

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

0 Answers  

---