Explain sql server service broker?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

What is snapshot replication?

0 Answers  

---

Which is better statement or preparedstatement?

0 Answers  

---

How to Execute an Operating System Command From Within SQL Server ?

3 Answers  

---

What is data compression?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

What is the difference between primary key and unique constraints?

0 Answers  

---