Answer Posted / tap_ks

SQl Profiler is a tool provided by SQL Server, which can
capture the queries, procedures executed on the database.
It also capture all the details like user, m/c, input
parameters, time of execution etc. This is very helpful
while bebugging any query / procedure.

What are the aggregate and scalar functions?

1068

---

Can you explain what is indexed view? How to create it?

904

---

What are the various editions of sql server 2017 that are available in the market?

892

---

Do you know what is openxml in sql server?

1068

---

Can you please differentiate between a primary key and a unique key?

1009

---

What is normalization 1nf 2nf 3nf?

1060

---

How can you append an identity column to a temporary table?

954

---

Is sql server implemented as a service or an application? : Sql server database administration

963

---

Explain filtered indexes?

1001

---

How to maintain a fill factor in existing indexes?

1006

---

What is normalization and its types?

1033

---

Why use “nolock” in sql server?

1058

---

How each E-R model constructs can be mapped to the relational model?

1003

---

How to select an exiting database using mssql_select_db()?

989

---

How to declare and use cursor variables?

1171

---