What are the aggregate and scalar functions?
No Answer is Posted For this Question
Be the First to Post Answer
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
how to replace double quotes by single quotes in sql server
What is openrowset sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What triggers long term care?
What is an index in sql?
How to view existing indexes on an given table using sp_help?
Can an automatic recovery be initiated by a user?
How many clustered indexes there can be on table ?
Write a program to fetch first 10 records from a file?
Define Check points and End Points?
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,
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)