Explain the different types of joins?

0 Answers  

---

what information is maintained within the msdb database? : Sql server administration

0 Answers  

---

Detail about query optimizer?

0 Answers  

---

diffrence between function and procedure

5 Answers   Wipro,

---

Can we do dml on views?

0 Answers  

---

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

What do you mean by normalisation?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,

---

Explain logical operators in sql server?

0 Answers  

---

What is entity data services?

0 Answers  

---