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
- 912 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
what is normalization? Explain different levels of normalization? : Sql server database administration
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
What is attribute? : sql server analysis services, ssas
Is it possible in sql table to have more than one foreign key?
What is the recommended total size of your memory optimized tables?
What is compression - row-level and page-level compression?
How to remove duplicate rows from table except one?
Define msdb database?
How to check if stored procedure is running in sql server?
Diffrent types of function
What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
Can group functions be used in the order by clause in ms sql server?
-
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)
