Answer / Vivek Prasad

Here's an example SQL query in SQL Server to fetch the first 10 records from a file. Assuming the table is named 'TableName'.n`SELECT TOP 10 * FROM TableName;`

What part does database design plays a role in performance of an sql server-based application?

1 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1 Answers  

---

Can group functions be mixed with non-group selection fields in ms sql server?

1 Answers  

---

How to include date and time values in sql statements?

1 Answers  

---

How to create database with physical files specified in ms sql server?

1 Answers  

---

Can you force a query to use a specific index?

1 Answers  

---

What is the difference between indexing and hashing?

1 Answers  

---

How to Insert multiple rows with a single insert statement?

1 Answers  

---

What are the difference between data length and length in SQL Server-2008?

3 Answers   Scio Healthcare,

---

How to create new table with "create table" statements?

1 Answers  

---

Explain datetimeoffset data type in sal server 2008?

1 Answers  

---

How will you decide the active and passive nodes?

1 Answers  

---