If you have a table with a massive amount of records and the table can't change, how would you optimize a query that's taking too long? (This is more about getting results as fast as possible and not pigeon holing the solution to a query.) Assuming the query has been optimized, what else can you do to speed up performance? (Prepare to enter DBA and systems architect territory at this point.)
None
Add a row Delete a row Update a row what is the definition of "table" and "row" arrange in ascending and descending order
What is a stored procedure and view?
Sorry I don't remember the questions.
SQL server Architecture
Self introduction, advantages of views, difference between where and having clause.
what are performance tuning techniques you have used
Based on Joins Only
Included Reasoning questions, SQL questions too
Viewing 811 - 820 interview questions