Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors you will check for the performane
optimization for a database query?
- 7 Answers
- 11711 Views
- CarrizalSoft Technologies, DELL, SoftSol, I also Faced
- E-Mail Answers
Answer Posted / bata
i think above 2 answers arent much betr.wil try to give
perfect answer soon
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Explain the disadvantages of cursors?
What structure can you implement for the database to speed up table reads?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What happens if you add a new index to large table?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
Explain what is lock escalation?
How to send email from database?
Detail about the hardware which is supported by SQL server?
What methods do you follow to protect from sql injection attack?
Scalability, Availability, Integration with internet, etc.)?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
difference between Clustered index and non clustered index ?
What are different types of table joins?
What is exporting utility?
what is denormalization and when would you go for it? : Sql server database administration
