ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to perfor If the table running time is taking 2hours 
and table is having 10 rows in it?
 Question Submitted By :: Vamsimadineni
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to perfor If the table running time is taking 2hours and table is having 10 rows in it?
Answer
# 1		 
I guess something must be seriuosly wrong with Server not 
with that table.

Since a table with 10 records must not be taking 2 hours to 
perform any operation (INSERT,UPDATE,DELETE,SELECT) or 
Indexing anything else.

Where is this question asked?

Thanks,
Bru Medishetty
www.LearnSQLWithBru.com
 
Is This Answer Correct ?    0 Yes 0 No
Bru Medishetty
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ? Wipro4
Can you have a nested transaction? HCL3
Advantages and Disadvantages of Cursor? Zenith10
If there is failure during updation of certain rows, what will be the state?  1
write query for fourth maximum salary from employee table Mind-Tree5
What is difference beteen Migration and Upgrdation? Satyam4
What is the purpose of using COLLATE in a query?  1
Questions on identity? Infosys1
Questions regarding Raiseerror?  1
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha  4
create index a on employee(dno) In this,which index was created?  2
how do u do Performance tunning ? Satyam1
How do you measure the performance of a stored procedure? Infosys1
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer. Satyam4
When do you use SQL Profiler?  2
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3 Google10
Which virtual table does a trigger use? TCS6
can you any body tell me the how to decrease the logfile  4
How can I know what query is executing by by a particural user? (using sp id or any othe way.)  2
What is SQL Profiler what is the use of it? 247Customer2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com