Does group by sort data?
No Answer is Posted For this Question
Be the First to Post Answer
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 an example of a primary key?
Explain the usage of floor function in sql server.
What's the difference between DELETE TABLE and TRUNCATE TABLE commands?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
How to skip remaining statements in a loop block using continue statements?
CLR Integration ? what is Notification services ?
Which database stores information about replication?
Is the log file is a part of file group?
What are the disadvantages of using querystrings to send data from one page to another?
What is Sqlpaging in SqlServer 2005 ?
What is the dbcc command and why is it used?
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)