I think i will try it in production maybe i will see somethink 🙂 thanks for all..

Gila maybe you are right but i just test it in with sqlquerystress tool and i execute 500 times perf1 and perf2 the same conditon perf1 is 10.8 second...

This are same queries with the same where conditions but the diffrence between this

queries i only remove inculude columns for perf2 they are use the same index

and when i remove...

This are the same queries but i only remove the inculude columns in the index in the perf2 this queries are used the same index that why i...

After i wrote this topic i made another test and i give another report and this is a update query

I think perf2 is better

perf1

SQL Server parse and compile...

Deadlock Graph

<TextData>

<deadlock-list>

<deadlock victim="process15e94988">

<process-list>

<process id="process15e94988" taskpriority="0" logused="77928" waitresource="KEY: 7:72058041283117056 (60b438c2a4e5)" waittime="4667" ownerId="13857101193"

...

Any idea?

I want to make it but i can t explain it maybe a lot of time i drop and create index rebuild and reorganize but i could not

I drop and create index rebuild index reorganize index but i could not do it

Sorry i want to make fragmention of index about 100

80

We have a ERP system and that tables will not use 2012.

I can set this tables index fill factor 80 to 95 in 2012 I gain some space

I...

I have a lot of indexes i want to learn if I need shirink fill factor 80 to 95 to use data space...

I solve my problem with impersonate......

I have a web site and it is in a pc and that pc is in a domain but i want to use different domain user to login SQL SERVER

for...