Answer Posted / guest

4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.

Why use cursor in sql server?

547

---

What is difference between views and stored procedures?

508

---

What is plan freezing?

584

---

How to view existing indexes on an given table using sp_help?

591

---

What is nolock?

552

---

---

What are the different types of backups avaialabe in sql server 2005?

620

---

What are the new security features added in sql server 2012? : sql server security

532

---

What is difference between count (*) and count column?

523

---

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

521

---

what are constraints? Explain different types of constraints? : Sql server database administration

503

---

What are key, name and value columns of an attribute? : sql server analysis services, ssas

571

---

What is a trigger what are the advantages of trigger?

524

---

What is openxml in sql server?

616

---

Can we use pragma autonomous_transaction in trigger?

537

---

What is the definition for sql server 2000?

585

---