Answer Posted / swapna

SQL Server can be started from command line, using the
SQLSERVR.EXE. This EXE has some very important parameters
with which a DBA should be familiar with. -m is used for
starting SQL Server in single user mode and -f is used to
start the SQL Server in minimal confuguration mode. Check
out SQL Server books online for more parameters and their
explanations.

Is BCNF better than 2NF & 3NF? Why?

1002

---

What are logical database components? : SQL Server Architecture

958

---

What is the difference between a local and a global temporary table?

1052

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2261

---

How to delete an existing database user?

967

---

what are different types of backups available in sql server? : Sql server database administration

888

---

What will be query used to get the list of triggers in a database?

953

---

Explain what is use of dbcc commands?

986

---

Can a unique index be created on a column, which contains null?

877

---

Explain powershell included in sql server 2008?

996

---

What is b tree index?

855

---

User wants only to display only pdf as export option in report manager. How to achieve this?

247

---

What is temporary stored procedure?

895

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

837

---

What is self contained multi valued query?

944

---