Answer Posted / suraj

like this

select *
from dbo.Address
with (nolock)

-- above query doesn't hold lock while retrieving data.

how many clustered indexes can be created on a table? : Sql server database administration

1155

---

Why do we partition data?

1034

---

How to insert a new row into a table with "insert into" statements in ms sql server?

975

---

Explain how dts is used to extract, transform and consolidate data?

1000

---

What is a cursor, index in sql?

1074

---

You want to use a perspective in an mdx query. How do you select the perspective?

239

---

What are different backups available in sql server?

1079

---

When I delete any data from a table, does the sql server reduce the size of that table?

1021

---

what is a schema in sql server 2005? : Sql server database administration

1034

---

What are temporal tables in sql server 2016?

888

---

How to truncate the log in sql server 2012? : sql server database administration

1292

---

Explain the properties of the relational tables?

996

---

How to execute a sql statement using odbc_exec()?

1146

---

What is ms sql server index?

1109

---

How do I schedule a sql server profiler trace?

983

---