What are the types of model in sql server and explain
Answers were Sorted based on User's Feedback
Answer / laxman
i think that may be recovery model
simple
bulk-loged
full
Is This Answer Correct ? | 4 Yes | 1 No |
Do you know what is difference between index seek vs. Index scan?
Explain subquery and state its properties?
What are constraints?
What is analysis service repository?
How do I list the available tables in a database I'm querying?
What is normalization and what are the advantages of it?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
Why is replication required on the sql server?
In what sequence sql statement is processed?
Diffrence between DTS vs SSIS
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How do you fine the performance tunning?