Answer Posted / vidit tyagi

SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName,
last_user_update,*
FROM sys.dm_db_index_usage_stats
WHERE database_id = DB_ID( 'DataBaseName')
AND OBJECT_ID=OBJECT_ID('TableName')

How to provide login information for a new odbc dsn?

1050

---

What is filtered index?

1090

---

How many servers can we create in a single subscription?

162

---

Is oracle faster than sql server?

948

---

What is a hint?

991

---

What happens when converting big values to integers?

995

---

what's the difference between delete table and truncate table commands? : Sql server database administration

978

---

why would you call update statistics? : Sql server database administration

1086

---

Difference between group by clause and having clause in SQL?

971

---

Do you know clustered and non-clustered index?

977

---

What is extended stored procedures?

966

---

Mention the different types of replication in sql server.

1021

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1038

---

What is the command to change the recovery model?

1045

---

What is self join in sql server joins?

1055

---