For Disk Delays

===========

select DB_NAME(database_id) DB_NAME, di.file_id,df.name,io_stall_read_ms ,num_of_reads

,cast(io_stall_read_ms/(1.0+num_of_reads) as numeric(10,1)) as 'avg_read_stall_ms'

,io_stall_write_ms,num_of_writes

,cast(io_stall_write_ms/(1.0+num_of_writes) as numeric(10,1)) as 'avg_write_stall_ms'

,io_stall_read_ms + io_stall_write_ms as io_stalls

,num_of_reads + num_of_writes as total_io

,cast((io_stall_read_ms+io_stall_write_ms)/(1.0+num_of_reads + num_of_writes) as numeric(10,1)) as...

CREATE NONCLUSTERED INDEX [_dta_index_dClientCode_16_437576597__K7_K3_1] ON [dbo].[dClientCode]

(

[ClientGenericId] ASC,

[Code] ASC

)

INCLUDE ( [ClientCodeId]) WITH (SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = ON) ON [Data_Data]

Use online= off recommended,some indexes...

Create DISK of VM on different physical partition of SAN of host then you have different LUNS

use Database Audit Specification against particular object or schema,you can capture all stuff

http://msdn.microsoft.com/en-us/library/cc280386.aspx

http://technet.microsoft.com/en-us/library/cc280404.aspx

use Database audit specification against msdb database because all jobs information insert or update in this database

http://msdn.microsoft.com/en-us/library/cc280386.aspx

http://technet.microsoft.com/en-us/library/cc280404.aspx

both Server specifications are same ? like Processor , RAM ,Drives etc

select CONVERT(numeric(18,4),getdate(),101);

Update Table set datecolumn = CONVERT(numeric(18,4),datecolumn,101);

Note

First take backup your database and test it on sample data first then come to production Server

Send Table Definitions is there FK and AuditType is another table ?

same information and same columns

Union is a solution,normalize the structure then you can apply joins

declare @folderName varchar(500)

declare @sql varchar(1000)

set @folderName = 'Empty'

select 'PRINT ''' + '---' + REPLACE(SQLNAME,'.sql','') + '''' +

' :r ' + @FolderName + '\' + SQLNAME

from [dbo].[PATCHFILE]

SELECT @sql = 'BCP...

User Parameterization to Forced

check this query

select top 50

st.text

,qt.query_hash

,qt.query_plan_hash

,qt.plan_generation_num

,execution_count

,total_physical_reads

,total_logical_reads

from sys.dm_exec_query_stats qt

cross apply sys.dm_exec_sql_text(qt.sql_handle) st

where total_physical_reads > 10

that is the problem of SQL Server service account,give write rights on the user which one using for the SQL server service account,if you are taking backup on the shared...

Auto Update Statistics True

Auto Update Statistics Asynchronously True

Don't over kill the indexes

if require rebuild then rebuild the indexes and if required reorganize then reorganize it,dont apply rebuild on all indexes

1-avg_fragement_percent...

IIS 7.0 or later is available ?

This query inform you about the usage of tempdb space

SELECT

SPID = s.session_id,

s.[host_name],

s.[program_name],

s.status,

s.memory_usage,

granted_memory = CONVERT(INT, r.granted_query_memory*8.00),

t.text,

sourcedb = DB_NAME(r.database_id),

workdb...