Answer / Mritunjay Kumar Pandey

A Linked Server in SQL Server allows you to access tables on another SQL Server instance or even other data sources like Oracle or Access as if they were local. This enables querying, updating, and executing stored procedures across different databases.

How to find index size for each index on table?

1 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

1 Answers  

---

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

---

Explain the commands in sql server?

1 Answers  

---

what is DTS what are tasks available

1 Answers   Wipro,

---

Why main is user defined function?

1 Answers  

---

Where is trigger in sql server?

1 Answers  

---

What is Left Outer Join?

2 Answers  

---

Explain active/passive and active/active cluster configurations?

1 Answers  

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1 Answers  

---

How to verify a user name with sqlcmd tool?

1 Answers  

---

Can a table be moved to different filegroup?

1 Answers  

---