Answer Posted / manoj

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

Explain what is the function of sql server agent windows service?

1040

---

What is difference between views and tables?

1076

---

What is view in sql?

950

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

125

---

What is the difference between substr and charindex in the sql server?

1181

---

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

1087

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1022

---

What is side by side migration in sql server?

1170

---

Tell me in brief how sql server enhances scalability of the database system?

1040

---

how will add additional conditions in sql?

1169

---

how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1107

---

What is an expression in ms sql server?

1140

---

Mention the different types of replication in sql server.

1069

---

How to disable stored procedure sql server?

1660

---

List out what other servers you can use with ssrs?

145

---