Question About SQL Cache or Page File

Question

Question About SQL Cache or Page File

nilay_ocal

Newbie

Points: 3
More actions
May 16, 2014 at 10:55 am

#293459

Hi,
In my company, we have a huge database (about 63 GB). In this database, we have an table, which have 15 million data in it. This table has an identity column, with incremantal (1,1) condition. This table is a stock operations table. So the problem is;
In this table, January term is locked by the accounting operations, so no one write any data to January. But accidentally I realize that, some data write this table yesterday. But the problem is starting right now. We have identity column, as I said before. This inserted column has an ID, which if it created real day of the data (in february). If this row inserted without bulk insert, it must take the ID upper than 18000, but this ,inserted row take an id like 15600 etc. Also I must say, we have no log data about insert, delete or update.
My question is, sql can hold data in memory, page file, log file or something like that, and can write this data after 3 months later?
Thanks for your help,

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 1

No, SQL won't by itself suddenly write data from 3 months ago. If you're seeing inserts happen, something or someone is running those inserts.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nilay_ocal Newbie Points: 3 More actions · Answer 2

Of course, I know that, because it is not possible. But before blame someone, I want to ask if I know false. So this person is professional because, firstly delete rows with the ordinary ID, and hold this data, and after accounting term, insert this data with bulk insert with checked identity insert on.

Thanks for your reply,

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 3

Time to give your legal dept (and maybe HR) a call, then investigate. I hope you have some auditing in place.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nilay_ocal Newbie Points: 3 More actions · Answer 4

nilay_ocal

Newbie

Points: 3

May 16, 2014 at 11:53 am

#1714275

I hope so.

Thanks for your reply,

Eirikur Eiriksson SSC Guru Points: 182948 More actions · Answer 5

First thing to run

SELECT

*

into dbo.myAudittable

FROM sys.dm_exec_connections c

cross apply sys.dm_exec_sql_text(c.most_recent_sql_handle)

If you are lucky, you'll have the culprit there.

😎