Answer / 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.

Answer / ganeshsamurti

• Open "Control Panel->Administrative Tools->Services"
• Mouse right click on specified SQL Server instance service
and select "Properties" menu to bring up following
configuration window:

• Specify start parameters as following:

-s{ Instance name } -m

If instance is default instance (no instance name) ,then
just enter

-s -m
• Restart the SQL Server instance service



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.

Answer / abc

sqlserver.exe is located in the binn dir of sql server ie
program files\m sql server\mssql\binn and we can get help
related to it on dos prompt
to start server at single user mode or admin role we have
to specify -m ahead of the command

Can you please explain the difference between function and stored procedure?

1 Answers  

---

What are the advantages of stored procedure in sql server?

1 Answers  

---

Difference between LEN() and DATALENGTH() in sql server ?

1 Answers   HCL,

---

How to select Distinct columns from the table, table having 20 columns and i want all coulmns

5 Answers   Wipro,

---

How can you find out how many rows returned in a cursor?

1 Answers  

---

how many triggers you can have on a table? : Sql server database administration

1 Answers  

---

Do you know what are acid properties of transaction?

1 Answers  

---

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers   TCS,

---

How to use copy and concatenate commands in SQL?

1 Answers   Amdocs,

---

Name 3 ways to get an accurate count of the number of records in a table?

1 Answers  

---

what are the Prerequisites for Replication?

2 Answers   IBM,

---

Explain system views?

1 Answers  

---