Answer / dilipkumar

there are 1 clustered index and...
in 2008 sql server total 249 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Answer / vikram

there are 1 clustered index and...
in 2005 sql server total 249 non clustered index
in 2008 sql server total 999 non clustered index
in 2010 sql server total 999 non clustered index
in 2012 sql server total 999 non clustered index.

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

Why do we use stored procedures in sql server?

1 Answers  

---

How to create a large table with random data for index testing in ms sql server?

1 Answers  

---

what is the sql equivaent of the dataset relation object ?

1 Answers  

---

syntax for deleting the database in T SQL

5 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,

---

what is sql server? : Sql server database administration

1 Answers  

---

What stored by the master?

1 Answers  

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1 Answers  

---

What is change data capture (cdc) feature?

1 Answers  

---

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

1 Answers  

---

What is public role in sql server?

1 Answers  

---