how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

What is a file group?

0 Answers  

---

What is the default sql server instance name?

0 Answers  

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers  

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

How much space does sql server 2016 take?

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

What are scalar functions?

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What are system databases into sql server (2005/2008)?

0 Answers  

---

How to create a simple stored procedure in ms sql server?

0 Answers  

---

How to convert character strings into numeric values?

0 Answers  

---