Answer / bru medishetty

A Trace Flag (not Trace Frag) is used inorder to
activate/suppress a certain behaviour of the SQL Server.

You need to restart the SQL Server after adding the Trace
Flag.

Thanks,
Bru Medishetty
www.LearnSQLWithBru.com

What is join and name different type of joins?

0 Answers  

---

How to generate create procedure script on an existing stored procedure?

0 Answers  

---

What is plan freezing?

0 Answers  

---

How can I check that whether automatic statistic update is enabled or not?

0 Answers  

---

What is the query and subquery?

0 Answers  

---

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

---

What is the difference between truncate and delete commands?

0 Answers  

---

Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,

---

How to get the definition of a trigger back?

0 Answers  

---

Do you know concepts and capabilities of sql server?

0 Answers  

---

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers   Techno Solutions,

---

How can we improve performance by using SQL Server profiler?

0 Answers   QuestPond,

---