What is a cursor, index in sql?
No Answer is Posted For this Question
Be the First to Post Answer
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........
What's the maximum size of a row?
What is dbcc command in sql server?
How to connect of datebase with sql express.?
Can you index views?
what does the automatic recovery do? : Sql server administration
What is sql stored procedure?
What is Left Outer Join?
How do you rename a table in sql server?
how to find the second salary?
Oracle (3253)
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)