Answer / Pitamber Arya

Partitioned views in SQL Server are similar to regular views but consist of multiple physical partitions. Partitioning allows large data volumes to be divided into smaller, more manageable pieces, improving query performance and reducing resource consumption. Each partition can reside on a different file group, which can be located on separate disk drives or storage devices.

How to replace null values in expressions using isnull()?

1 Answers  

---

From where can you change the default port?

3 Answers  

---

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

1 Answers  

---

What is log shipping?

1 Answers  

---

What is instead of dml trigger?

1 Answers  

---

Write a query for primary key constraint with identity key word?

1 Answers   MindCracker,

---

Does the order of columns in update statements matter?

1 Answers  

---

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?

8 Answers   IBM,

---

Which tcp/ip port does the sql server run on? How can it be changed?

1 Answers  

---

What is tcl in sql server?

1 Answers  

---

What is a collation?

1 Answers  

---

What are database states in ms sql server?

1 Answers  

---