What are the types of subscriptions in SQL Server replication?

0 Answers   HCL,

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---

What is auditing in sql server?

0 Answers  

---

What is the purpose of the tempdb database?

0 Answers  

---

How to create a user to access a database in ms sql server using "create user" statements?

0 Answers  

---

How can windows applications connect to sql servers via odbc?

0 Answers  

---

What are the steps you will take, if you are tasked with securing an SQL Server?

1 Answers   HCL,

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

What is a filestream?

0 Answers  

---

How is table type constraint applied to a table?

0 Answers  

---

Explain trigger and its types?

0 Answers  

---