Answer / Shobhit Tyagi

To view a trace file (.trc) in SQL Server, you can use tools like SQL Server Profiler or SQLCMD with the -v option to parse the events and display them.

Explain timestamp datatype?

1 Answers  

---

Which data type columns are the best candidates for full-text indexing?

1 Answers  

---

What samples and sample databases are provided by microsoft?

1 Answers  

---

Is the log file is a part of file group?

1 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

How can you start sql server in different modes?

1 Answers  

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1 Answers  

---

Is port 1433 secure?

1 Answers  

---

user defined datatypes

1 Answers   Wipro,

---

Describe how to use linked server?

1 Answers  

---

What are the different methods available under sqlcommand class to access the data?

1 Answers   UGC Corporation,

---

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

---