Answer Posted / varinder sandhu

Dear All,

normally sql sever 2000 supports 16 instance,
this is right.

in 2005 max number is not 50

because sql server 2008 R2 Datacenter supports 25 instance only

i don't think previous version sql server mean 2005 support
50 new 2008 R2 support only 25

it does not make sense.

Ref Article :
http://www.microsoft.com/sqlserver/2008/en/us/R2-editions.aspx

Thanks,
http://varindersandhus.blogspot.com/

What are the properties of sub-query?

585

---

What is the significance of null value and why should we avoid permitting null values?

536

---

Give an example of why you would want to denormalize a database

520

---

What is the difference between a "where" clause and a "having" clause?

623

---

What is the difference RDBMS and Graph Database?

633

---

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

504

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

876

---

What is partitioned view?

529

---

Can you insert NULL in unique column?

635

---

Can foreign key be duplicate?

635

---

How do I run a trace in sql server?

508

---

Mention the 3 ways to get a count of the number of records in a table.

555

---

How can you check the level of fragmentation on a table?

612

---

How to execute function in stored procedure sql server?

547

---

Explain full-text query in sql server?

542

---