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 is nonclustered index with included columns ?

1018

---

A trigger can reference objects outside the current database? State true or false.

1060

---

What are information schema views?

1033

---

what's new in sql server 2016?

1003

---

what changed between the previous version of sql server and the current version? : Sql server database administration

1054

---

How to rebuild all indexes on a single table?

1109

---

What is the default order of an order by clause?

1038

---

What are the purposes of floor and sign functions?

1020

---

Explain important index characteristics?

1080

---

Explain what is cte (common table expression)?

1191

---

How to change server name in sql server?

1254

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1165

---

What are character string data types in ms sql server?

1349

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1175

---

What are the differences between char and varchar in ms sql server?

1125

---