Answer Posted / Mohd Yameen

To find the first and last day of the current month in SQL Server, you can use EOMONTH function:nn```sqlnSELECT EOMONTH(GETDATE()) + 1 AS LastDayOfMonth,n EOMONTH(GETDATE()) + 1 - DATEPART(DAY, GETDATE()) AS FirstDayOfMonth;n```

When should you use an instead of trigger?

1042

---

What is the primary use of the model database?

1144

---

Can we shrink data file in sql server?

1123

---

What is subquery? Explain the properties of a subquery?

1056

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1188

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1126

---

What is temporary table in sql server? Why we use temp table?

1010

---

How do I find query history in sql server?

1018

---

List out the different types of locks available in sql server?

1045

---

Does view occupy space?

1005

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

---

What is a scheduled job or what is a scheduled task?

1031

---

Can sql servers link to other servers like oracle?

910

---

What are the different types of subquery?

1228

---

How can I check that whether automatic statistic update is enabled or not?

1108

---