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   SiteMap shows list of All Categories in this site.
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 do you know which index a table is using?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How do you know which index a table is using?
Answer
# 1
sp_helpindex command gives the information of the indexes 
on the table
 
Is This Answer Correct ?    6 Yes 0 No
Chandra Rekha
 
  Re: How do you know which index a table is using?
Answer
# 2
dbcc traceon 302
 
Is This Answer Correct ?    0 Yes 3 No
Vimal
 
 
 
  Re: How do you know which index a table is using?
Answer
# 3
sp_helpindex tabelname
 
Is This Answer Correct ?    7 Yes 0 No
Hari
 
  Re: How do you know which index a table is using?
Answer
# 4
sp_help <tablename>
sp_helpindex <tablename>
 
Is This Answer Correct ?    4 Yes 1 No
Visala
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Differnce between sel server 2000 and 2005  3
What are the pros and cons of creating extended stored procedures?  1
how many joins we can write if at all we have n no of tables Tanla-Solutions4
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes.. Rolta5
write down the code for "how we delete a table without using of Drop command " ? Sonata2
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table. Techno-Solutions2
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  2
What does it mean to have quoted_identifier on? What are the implications of having it off?  2
What is user stored procedure & it purpose? Wipro3
Difference between sql server 2000 and sql server 2005? Satyam4
What are primary keys and foreign keys?  3
What are the types of backup and tell me the difference between full and differential backup? TCS3
Why we need a group by clause?  3
Rate yourself in .NET and SQL ? Cognizent1
How do you check the performance of a query and how do you optimize it?  1
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  3
From where can you change the default port?  3
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL? HCL3
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required  2
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?  2
 
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