Monday 17 February 2014

Sql Server Profiler & Database Engine Tuning Adviser

Sql Server Profiler & Database Engine Tuning Adviser  


Step 1: Write a Query
(I have collected this from Microsoft web)

EMP, DEPT Sample script

/****** Object:  Table [dbo].[DEPT]    Script Date: 19-05-2016 06:58:37 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET A...