Answer / Jhamman Lal

A global temporary object (table or stored procedure) is an object that is accessible to all connections in the instance of SQL Server. When a global temporary object is created, it's given a unique system-generated name and exists only for the duration of the current database session.

Explain the architecture of SQL Server?

2 Answers   ABC, HP, Oracle,

---

Write down the syntax and an example for create, rename and delete index?

1 Answers  

---

Explain what is row_number function?

1 Answers  

---

Which command is used for user defined error messages?

1 Answers  

---

What is the tcp/ip port on which sql server runs?

1 Answers  

---

What is the return type of executeupdate ()?

1 Answers  

---

How many clustered indexes there can be on table ?

1 Answers  

---

How do I start sql server 2017?

0 Answers  

---

What is the purpose of forms?

1 Answers  

---

What is fill factor and pad index?

1 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1 Answers  

---

How do you check the performance of a query and how do you optimize it?

1 Answers  

---