Explain what is raid and what are different types of raid levels?
How to create user defined functions with parameters?
What command do we use to rename a db, a table and a column?
What is the difference between nvl and nvl2?
List down some advantages of sql stored procedure?
How the data stores in a page?
How can delete duplicate records in cte in sql server?
What is the difference between seek predicate and predicate?
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
What is the difference between count () and rowcount ()?
can we have a nested transaction? : Sql server database administration
What is the sql profiler?
What is difference between commit and rollback when used in transactions?