How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

What do you mean by authentication modes in sql server?

0 Answers  

---

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

---

What are the different types of upgrades that can be performed in sql server?

0 Answers  

---

What is difference between temp table and cte?

0 Answers  

---

---

What is master database? : SQL Server Architecture

0 Answers  

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---

could u plz explain about joins and views?

2 Answers  

---

Where are full-text indexes stored?

0 Answers  

---

Tell me about Triggers?

3 Answers   Cap Gemini,

---

CTE(common table expression)

1 Answers   Thomson Reuters,

---

How to insert stored procedure result into temporary table?

0 Answers  

---