In SQL Server there is a job runs daily, pulls data from flat files, The flat files are published by a third party vendor, we got a situation, one fine day Job didn’t ran, we missed that days data, next day vendor has overwritten flat files, because they will give flat files with same name daily.
We need to have design, if we missed the data of last day also we should be in a position to pull the data.
What are the different ways of pulling data from Flat/Excel files
How to execute sql statements which is in a text file?
You have a flat file, how to pull data into a table which is having a Identity column?
What are the different things you will take care while writing a Stored Procedure?
I have below tables of a Student Database.
SID, ClsID, SUBID, Marks
Write a query to get topper of the student?
Write a query to get student details who are not attended at least one exam?
if we cannot write above query what is the change in the above data model, to make it easy.
What are the different transaction isolation levels?
How did we provided column level security in our project?
What are the different data flow tasks we have in SSIS?
What are the different providers in SSIS to pull the data from different sources?
What is most challenging task you have ever faced? how did you handled it
Which lock will on a table when you put WITH (NOLOCK) in your select statement?
What are the different types of Locks in SQL Server and what is the concept of Lock escalation?
What is the difference between ISNULL, COALESCE and NULLIF?