Enable it.

From Kimberly Tripp

Performance Test with Zero Initialization

Hardware: Dell Precision 670 Dual Proc (x64) with Dual Core, 4 GB Memory, RAID 1+0 array w/4-142 GB, 15000rpm disks

...

Try this

CREATE EVENT SESSION [Deadlock Graphs] ON SERVER

ADD EVENT sqlserver.xml_deadlock_report(

ACTION(sqlserver.database_id,sqlserver.database_name))

ADD TARGET package0.ring_buffer(SET max_events_limit=(50),max_memory=(51200))

WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=30 SECONDS,MAX_EVENT_SIZE=0 KB,MEMORY_PARTITION_MODE=NONE,TRACK_CAUSALITY=ON,STARTUP_STATE=OFF)

GO

That is my deadlock session.

Then you can double...

Are you checking deadlocks with extended events?

Rebuilding an index, for example by using the ALTER INDEX...

check missing indexes.

You could be caching whole tables and doing table scans in memory, which could be why cpu is high.

Before you maybe couldn't cache the whole table so a...

create table Temp(id int,SAPDATA varchar(6))

insert into temp

select 1 ID, 'ABC' SAPDATA

UNION ALL

select 2 , '100'

UNION ALL SELECT 3 , 'DEF' ...

Just en closing.

These...

Hugo Kornelis (4/15/2016)

---

TheSQLGuru (4/15/2016)

---

Wrapping a function around a column in the WHERE clause is probably the second worst thing I see in aggregate in my consulting (with the first being...

Is the collation the same between the 2 servers and between the userDB and tempdb?

do you want included columns as well?

Also, not sure what the output is but .....

Doing all these calculations on unused or duplicate indexes is a waste.

So first find duplicate indexes,...

Wild stab as there is no DDL but maybe this.

There could be duplication caused by the joins though but I assume this would be more performant.

SELECT COUNT(distinct AUG.sub_id) AS PUBLIC_COUNT,

ACC.account_title...

I ran the below on adventureworks2012 running on a sqlserver2012 instance version 11.03156 have reproduced the issue.

Had to change the code to get it to run on adventureworks.

The subquery throws...

+1

UserID is the surrogate key, so this should be used to identify the row in this table when referenced from other tables.

It is int, so smaller than storing strings in...

amitsingh308 (4/7/2016)

---

Create table Script is as under:

Create table OrdersDetails(OrderNo varchar(30),ItemNo Varchar(20),ItemName Varchar(50))

insert script is as under:

Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('12231','1','sdfasfasd')

Now I want to change sequence number of ItemNo for...