You may come across the situation where you would not be able to stop the MS SQL service.

I came across very interesting query which can shutdown MS SQL server immediately without waiting for other processes.

Below query runs inside the query analyser of your ms sql server

 

SHUTDOWN WITH NOWAIT; 

Stop using command line  

Run => CMD

net stop mssqlserver

This will stop instance of MS SQL server

To start use:

net start mssqlserver

This will start ms SQL server

 Afterrestarting the server you may see data base in suspect mode if there exists uncommited transaction.
To bring database online you may require to perform these steps

Bring database online

Don't warry you can recover file from .mdf even if you don't have .ldf file. 

MS SQL SERVER CONFIGURATION MANAGER

You can open ms sql server configuration manager as shown in below fig.  

         Open SQL Server Configuration Manager. Here you can see various sql related services.
 Note: Look at the services which you are not using and stop them to avoid unnecessary cpu and memory consumtions.

The services like

1. SQL Server Integration Services (SSIS)
2. SQL Server Analysis Services (SSAS)
3. SQL Server Reporting Services (SSRS)

We rarely use those services as far as development is concerned. Stop them to gain performance of your server.

Satalaj.