Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
No Answer is Posted For this Question
Be the First to Post Answer
What is 1nf normalization form?
How are the exceptions handled in sql server programming?
Is it possible to delete duplicate rows in a table without using a temporary table ?
Explain powershell included in sql server 2008?
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).
Explain triggers in sql?
What are the advantages of stored procedure in sql server?
What is difference between count (*) and count column?
to explain sql server 2000 architecture & authentication
How do I find sql server instance name?
What is left outer join in sql server joins?