Top Panel

MS SQL Server

How to Restart SQL Server 2008

Created on Friday, 05 August 2011 15:53
Category: MS SQL Server
Hits: 114
  • Print

Restart SQL Server Using SQL Server Configuration Manger

  1. Click "Start" and navigate to "All Programs > Microsoft SQL Server 2008 > Configuration Tools"
  2. Click the "SQL Server Configuration Manger" icon
  3. Click the "SQL Server Services" entry on the left column
  4. Locate the "SQL Server (MSSQLSERVER)" entry on the main view
  5. Right-click the entry and click "Restart"

Restart SQL Server Using Windows Services Console

  1. Click "Start" > "Run" ["Run" is not displayed on the start menu by default in Win XP or later.  Select "Windows Key + R" combination to display the "Run" dialog]
  2. Type "services.msc" [without the quotes] in the "Open" text box and then click "OK"
  3. Locate the "SQL Server (MSSQLSERVER)" entry on the main view
  4. Right-click the entry and click "Restart"

Notes

  • You can also restart the SQL Server and SQL Server Agent services through SQL Server Management Studio if it is installed
  • If using the Express version of SQL Server, look for "SQL Server (SQLEXPRESS)"
  • Restarting SQL Server will disconnect connected users from their sessions with the server

An example of a static store procedure that use dynamic filters

Created on Friday, 05 August 2011 16:32
Category: MS SQL Server
Hits: 81
  • Print

Need an example of a static store procedure that use dynamic filters? [filters to search information for the user, that will be used in the query if they have information, if don't, that filters are disabled or at least the workaround they have to avoid the dynamic procedures?]

It may be because there is a client requirement where the client says something like "you can't use variables in the store procedures"

The key is in the where clause, let's say that you want to get a list of employees based on fields:

id_empresa, id_cargo, id_departamento, nro_personal and id_proceso, but you don't know what filter is the user going to choose, could be one or all, the query will look like this:

select *
from ph_empleados ph_e
where ph_e.id_empresa=isnull(@pr_id_empresa,ph_e.id_empresa)
and ph_e.id_cargo=isnull(@pr_id_cargo,ph_e.id_cargo)
and ph_e.id_departamento=isnull(@pr_id_departamento,ph_e.id_departamento)
and ph_e.nro_personal=isnull(@pr_nro_personal,ph_e.nro_personal)
and ph_e_p.id_proceso=isnull(@pr_id_proceso,ph_e_p.id_proceso)
If the user didn't choose a filter then the variable that contains the value will be null, and if that's the case the data is not going to be filter by that one