Answer Posted / naren

sp_help tablename

another command is

select name from syscolumns where id=object_id
('table_name')

What is an indexing strategy?

997

---

Explain what is scheduled job and how to create it?

948

---

What is your recommendation for a query running very slow? : sql server database administration

1036

---

Can one drop a column from a table?

1014

---

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1126

---

How does the report manager work in SSRS?

148

---

What is the full form of dql?

978

---

Explain different types of locks in sql server.

1070

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

960

---

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1050

---

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

960

---

What are cursors in ms sql server?

1171

---

How to generate create table script on an existing table in ms sql server?

1138

---

Can you tell me about the concept of ER diagrams?

1059

---

Does group by or order by come first?

952

---