Answer Posted / sanjeev kumar

SELECT OBJECT_NAME(OBJECT_ID) AS tablename,
last_user_update
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'your_database_name')
and user_updates>0
order by last_user_seek desc

What are a scheduled jobs or what is a scheduled tasks?

903

---

Explain “@@rowcount” and “@@error” in sql server?

1095

---

What is subquery? Explain the properties of a subquery?

990

---

What extended events?

1007

---

What is sub query and its properties?

974

---

What is default constraint?

1001

---

How many full-text indexes can a table have?

975

---

How to delete existing rows in a table?

1163

---

What is the difference between a fill factor of 100 and 0?

983

---

How to create a user to access a database in ms sql server using "create user" statements?

956

---

Explain how does the report manager work in ssrs?

958

---

What is scalar user-defined function?

1109

---

How do you debug a procedure in sql server?

954

---

Please illustrate physical database architecture? : SQL Server Architecture

990

---

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1044

---