Click here to Skip to main content
15,062,997 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
How/Where can I figure out the answers to these set of questions below in SQL Server?:

-Is the data in this table modified in any way?
-What is the data refresh frequency of this table?
-Do they keep historical data for each month this gets loaded? e.g. to do need to run a query to always grab the latest INFO table?


What I have tried:

I have not tired anything yet. I am a new DBA and need help to answer and understand these questions. TIA in advance
Posted
Updated 8-Dec-20 5:15am
v2
Comments
CHill60 8-Dec-20 8:44am
   
We can't see your screen, access your HDD nor read your mind. In other words - what table? What kind of table? How is it defined? Are there any triggers defined that affect it?
Nowhere near enough information here for us to help you
Dave Kreskowiak 8-Dec-20 9:52am
   
The only source you can examine to answer those questions is the rest of the information and database provided with the questions. Googling specifically for those answers will do you no good.
Member 15010041 8-Dec-20 10:28am
   
I should have worded this question better. I do not need the answers for the questions explicitly because I know it all depends on my environment. But I would just like to know where I can look inside SQL server to find the answers to my questions. Please let me know if that makes sense.

As a new DBA you probably need to find some good training materials: sql server learning - Google Search[^].
   
The questions depend on the table design they are discussing - and we have no access to that - and the code that is running against them - and we have no access to that either.

Even if we did, while we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.
   
Comments
Member 15010041 8-Dec-20 10:27am
   
Im sorry, I should have worded this question better. I do not need the answers for the questions explicitly because I know it all depends on my environment. But I would just like to know where I can look inside SQL server to find the answers to my questions. Please let me know if that makes sense.
In response to your comments..

Quote:
-Is the data in this table modified in any way?
You would need to know if there is any audit of data changes on the table. It might be a "temporal[^]" table for example or there may be asssociated Triggers that create audit entries[^]. Or the table itself might have columns that record when it was last updated and by whom (this is also often done by triggers).

You could always examine the Transaction logs - The Transaction Log (SQL Server) - SQL Server | Microsoft Docs[^]

You may be synchronising this data with a copy - in which case look at Synchronize Data - SQL Server | Microsoft Docs[^] or SQL Server Replication - SQL Server | Microsoft Docs[^]

Quote:
-What is the data refresh frequency of this table?
This very much depends on how the table is used. If it is application facing then you would need to know how often users access the application or you could use one of the techniques above to derive it. There may be regular jobs that update the data - in which case have a look at SQL Server Agent - SQL Server Agent | Microsoft Docs[^].
Quote:
-Do they keep historical data for each month this gets loaded? e.g. to do need to run a query to always grab the latest INFO table?
No idea what the latest INFO table is, but I assume you would access Job information to see how this table is queried/backed up for this purpose, or examine the actual data in the table itself.

You've got a lot of studying to do! Good luck with it
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900