this support of storage is supplier so i am not sure that i can trust him....

I found few sites, i will try set counters for these and i will see,...

or is it possible who has our server like linked server?

thanks

one point of this for me is for example rebuild indexes..I dont want to rebuild all 100GB tables ( With compression will be less,...

I am thinking about this, that my tables are not enought big for this, also 25milion rows is small if you have good indexes.. so maybe I will canceled this,,,,...

After update statistics with FULLSCAN still same ,

with use hint OPTION ( RECOMPILE ) I get more better result, same like without or with like scan 1, log.reads 20

I...

aaron.reese (11/5/2014)

---

Or partition the tables based on date; this gives you the best of both worlds: Performance where queries only need to hit one partition and full dataset (at the...

next advantage for separate

- backup only last database( this year ) , where are data inserted. ( not needed backup old years )

Jeff Moden (10/29/2014)

---

tony28 (10/29/2014)

---

I know this function, but I tried one times if I learned...

I know this function, but I tried one times if I learned sql 2years ago....

thank you, I found few topics about...

result with data in statistics are very good so I will not write here..

but result with data which aren in statistics in this time were very poor, after optimalization...

Hello guys, I disscused with one DB specialist and I found solution for my problem...

because with data in statistics was very good results, and this use execution plan with HASH...

ChrisM@Work (8/27/2014)

---

tony28 (8/26/2014)

---

ChrisM@Work (8/26/2014)

---

Query 2...

ChrisM@Work (8/26/2014)

---

Query 2 works very...

Eirikur Eiriksson (8/26/2014)

---

Quick thought, is it possible that the initial code was double pasted? Below is what I would guess it should be.

😎

SELECT

tB.ORDER_DATE

...