What meant by Performance Tuning,how can we do the performance tuning on stored procedures and tell some steps to do the performance tuning
TCS,
3 8297how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?
16 19647what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
1427could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
3 4167
Write a query to find 5th highest amount paid from the customer table.
Is it possible in sql table to have more than one foreign key?
Explain isolation levels that sql server supports?
What is the recursive stored procedure in sql server?
How to start and end transact-sql statements?
What are the purposes of floor and sign functions?
What is query parameter in ssrs?
What are different types of raid configurations? : SQL Server Architecture
What are the 3 types of schema?
Explain the categories of stored procedure?
In which sql server version report builder introduced?
What is the full meaning of dml?
What is difference between join and natural join?
What is transaction server consistency?
Why it is recommended to avoid referencing a floating point column in the where clause?