Answer Posted / sarvesh

CREATE PROCEDURE usp_StartStop_services

AS
Begin
Declare @date as varchar(100)
SET @date = convert(varchar, getdate(), 114)
Print @date

if @date >= '19:00:00.000'
exec MASTER.DBO.xp_cmdshell 'NET Stop SQLSERVER'
Else if

@date >= '09:00:00.00' and @date < '19:00:00.000'

exec MASTER.DBO.xp_cmdshell 'NET START SQLSERVER'
END
GO

What is the difference between commit and rollback?

942

---

Does index speed up select statements?

1011

---

Explain how to maintain a fill factor in existing indexes?

995

---

What is trace flag in sql server?

1020

---

What are distributed partitioned views?

1075

---

Define compound operators?

913

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1106

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

967

---

What is data modeling and Reterminal integrity?

1955

---

How many types of built in functions are there in sql server 2012?

926

---

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

110

---

New concepts of sql server 2005 use in your project.

2360

---

Distinguish between commit and rollback?

959

---

What are types of storage modes? : sql server analysis services, ssas

1039

---

what is a self join? : Sql server database administration

1038

---