Right actual data types.

Almost all time are parameters in procedures except few manual query..I know how procedures working and with first execution is still same execution plan.

If Iam using...

Hello,

this 89% it can be normal, but it can be allocated, you can check how much is free .. something like below

First is Free Memory,Target and Total SQL Memory ......

WHug (3/1/2016)

---

What are the row counts of the affected tables? If the tables are large, and the rows changing are under certain threshold (20%?) then stats may not auto-update....

Hugo Kornelis (3/1/2016)

---

tony28 (2/29/2016)

---

Hugo Kornelis (2/29/2016)

---

So why not write this as

WHERE A.1PKCOLUMN='DATE'

AND A.2PKCOLUMN > '+SEQ'

That would make it far easier for SQL Server to estimate the...

ChrisM@Work (3/1/2016)

---

The two rows with date '2010-02-04' have FID of 1 and 3. Your desired output lists FID of 2 and 3 for this date.

Can you explain how FID of...

hm I see only 2009-05-25 00:00:00.000 with FID 2, so how can you ensure that FID 2 will be ALSO in 2010-02-04 00:00:00.000.. you have in query some WHERE t.MDate...

and is possible open this network device with explorer ? like folder?

for example I have test server which is not in domain , but sometimes I need to get...

So now you have Date and FID , based on date.

I dont understand how can I recognize what is long time for you .

And next , it means that this...

If I good understand you can try this..

I tried for table with 90000 rows. time was about 52second...and got result with 68rows it means 68days ..

select distinct MDate,...

Test was without problem,,

update statistics for real database took about 1hour and there was some little performance increasing, so I think it can be, but has to be managed that...

You can use SELECT CURRENT_USER and SYSTEM_USER

You can use directly permission setting in SQL and select where you have access or no,

or create some helping table with columns USER and...

I have to opinions how to do..:

1 ) use linked server and during breaktime or weekend you can delete all data in all tables with some cursor and using...

So today I checked and it looks like Grant Fritchey wrote that Sample statistics dont do on all tables what I want...Interesting is that these tables have same count of...

Hugo Kornelis (2/29/2016)

---

So why not write this as

WHERE A.1PKCOLUMN='DATE'

AND A.2PKCOLUMN > '+SEQ'

That would make it far easier for SQL Server to estimate the cardinality, and it...

we found with wireshark error TDS7 pre-login authentication...

so if somebody will know let me know.. I will try something, but this is test server so when I will have time...