Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 0 Answers
- 894 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
could u plz explain about joins and views?
What is index in an assignment?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are sub-queries? Give example? In which case sub-queries are not feasible?
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?
Explain query editor regions
What value could be assigned to Varchar Type?
How do triggers work?
How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is 3nf normalization form?
-
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)
