I only have the one app on SQL and SSRS (but this will be moved soon - hopefully)

according to a DMV query CACHESTORE_SQLCP, USERSTORE_TOKENPERM and OBJECTSTORE_LOCK_MANAGER are using the most...

This is maybe a silly question, but does a reboot do the same job as clearing the buffers?

Its a 64bit server with max memory set to 38Gb

Hi thanks for confirming my fears over this

My problem is in this post

http://qa.sqlservercentral.com/Forums/Topic824404-146-1.aspx

This...

Thanks Adam, I have just dropped the memory down to 28Gb let it settle and then up'd it to 30Gb and my system has started working (not sure if this...

Initially I thought it was an IIS problem so I started to recycle that every hour but this made no difference.

SSRS also runs on this server and I stopped that...

I'm now using this which seems to be giving me the correct results

Select outletid, tillReceiptnumber+1

from ireceipt where outletid between 1001 and 1400

and effectiveon >= '2009-11-19 09:00:00' and effectiveon <...

Tillreceipt number is unique to each outletid but there will be duplicates in the table as each branch starts a tillreceipt number 1 and increases as they make trades.

My current...

I normally get

outletid then receiptnumber (if there is a missing receipt)

I would like a list of all outletid's where there is missing a receipt

Thanks

Thanks, I'd totally forgotten about LEN

How do you structure it if you want

where LEN (firstname, surname, addressline etc) > 1

?

Thanks

Actually no need to explain it, this is perfect

Thank you very much

Thanks for the reply, I'm not great (actually not even good with SQL) can you explain this to me please?

Say I have 3 different ID's

1001

1002

1003

1001 has receipt numbers 1, 2,...

Solution found

I set the first date to use a non-queried default of "=dateadd("d", -7, today())", while last date would default to "=dateadd("d", -1, today())" then when you subscribe the report...