Eirikur Eiriksson (8/25/2014)

---

tony28 (8/25/2014)

---

so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy for...

so what do you think, is any soulution than update statistics ? because with these high values I cannot use this procedure, this is very heavy for server if somebody...

interesting is that with data which were updatet statistics I have very good results--about 56000 rows

Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, read-ahead reads 0,...

I added second sql plan with query with condition before update statistics..

is this so big different between before and after ?

here looks almost ok

miss

GilaMonster (4/14/2014)

---

Hash matches aren't a problem, and without an execution plan nothing...

one next question..

If I do join more table ... it is needed join like this :

or can...

Thank you

Now I dont understand.

I read that more than 100rows can cause problem with INSERT, UPDATE, DELETE. I was suprised if I...

free_mascot (4/1/2014)

---

While configuring Data Collection it will create one database in which it will store the data collection. So definitely it will create some disk i/o however it depends on...

If I understand this is because it use almost same queries like Activity monitor every 10sec, and inside these queries are #table , yes?

If I understand this is because it use almost same queries like Activity monitor every 10sec, and inside these queries are #table , yes?

i turned off Query statistics collect and the MB/s to tempdb was rapidly decreased

i turned off Query statistics collect and the MB/s to tempdb was rapidly decreased

Lowell (3/27/2014)

---

I'd seen several similar posts on finding index creation date.

i'm very sure that there is no creation date exposed anywhere for indexes; objects in sys.objects have the create_date and...