Answer / payal nath

We can determine the last time a user table was altered
using the below query.

SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC

The modify_date column is updated whenever a column is
added or altered for the table.
It is also updated if the clustered index is changed.

Answer / manoj

select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)

Answer / manoj

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

How to define output parameters in stored procedures?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

What is mssql?

0 Answers  

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

What are the advantages to use stored procedures?

0 Answers   Ernst Young,

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

What is advantage data architect?

0 Answers  

---

How the data stores in a page?

1 Answers  

---

What does the update command do?

0 Answers  

---

What is Dependency Injection and provide example?

0 Answers  

---

What is index fragmentation in ms sql server?

0 Answers  

---