:ermm:

Are you using nolock hints or read uncommitted?

http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx

Well for sure editing an index could cause this.

This is the first I hear of stats being dropped. Tho I can understand the decision behind the behavior.

Other than a...

SELECT nCounter, vInOutTag, nEmpNo,

MAX(case when day(dtinout) = 1 then dtinout end) as col1,

MAX(case when day(dtinout) = 2 then dtinout end) as col2,

MAX(case when day(dtinout) = 3 then dtinout end) as...

I've never seen anything else that could explain this... will hang around just in case.

The one which is NOT the real prod server.

Go in SSMS, sql agent, create a new job. Paste your query there and schedule it however in it.

That actually can't happen. The restore of a backup is a perfect copy of the DB (including index and stats).

Either the backup is older than the db itself or...

Check the statsdate() for a few of those tables. If they match the date the job ran then it was updated and the "reporting" you're getting is misleading.

Also assuming...

AFAIK this could be done is a very small maintenance window.

Bring the prod server offline (shut down).

Open the other one. Rename the machine, server, @@servername. whatever you need.

Once...

Not that I know off. The real quesion is why do you care about that?

Each stats is very small on the HD.

Are you sure it had nothing to...

Mad-Dog (8/1/2011)

---

i only give you an example of when you call the EXE file that have space in it you must include the "" in the syntax,

and when i need...

Asked your domain admin??

50%-50% on this particular query. But I was talking more general cases (for future googlers).